Re: $$Excel-Macros$$ Need Urgent Help - Distance Calculator

Can anyone help me please... Thanks, Manoj Kumar On Mon, Apr 19, 2010 at 1:01 AM, Manoj Kumar wrote: > Hi Guys, > > I need a macro to calculate total distance between two states or > cities or both from a distance search engine.For example:- > http://www.mapquest.com/. > > Appreciate  ur help.

RE: $$Excel-Macros$$ Macro can no longer find Date-1 in spreadsheet

Hi, Are you sure that Date-1 (ie yesterday's date) actually exists in Col C? Perhaps it appears to exist, but is actually text, not a date. Regards - Dave. > Date: Mon, 19 Apr 2010 08:18:51 -0700 > Subject: $$Excel-Macros$$ Macro can no longer find Date-1 in spreadsheet > From: lauren.kl...@u

$$Excel-Macros$$ Re: Permutations and combinations

Take a look here: http://www.tushar-mehta.com/excel/templates/match_values/index.html#VBA_multiple_combinations On Apr 14, 1:21 pm, MD18358 wrote: > Hi All: > > I don't want the "number of Permutations" I want to see the > permutations to a calculated sum. > > For example:  How many different wa

$$Excel-Macros$$ Want to forece numbers to look like text with Green Error Flag

I want to force numbers in a combined text number column to look like text but be sorted as numbers. I tried the cell select and changed format of column to text but when I try and export the data to a specialized program like Monarch Pro V 10.5 Monarch interprets the numbers as numbers and in a c

Re: $$Excel-Macros$$ HELP: Appending multiple sheet into one

Hi Shyam, Please if possible if u can share file in unprotected vba. thanks & rgds On Mon, Apr 19, 2010 at 10:27 AM, rf1234 rf1234 wrote: > Hello CrazyBond > Actually this was my private project,perhapes that's the reason it > will be locked. > ok if u like this,i will try to send again witho

$$Excel-Macros$$ Save As - error - object required

Hi All, I am trying to create a macro that will first allow the user to define the path where files will be save to. Second, the macro creates several files and saves them into this user defined path. Below is my code and on the second line I get an error stating "object required" CODE: ' let t

$$Excel-Macros$$ Macro can no longer find Date-1 in spreadsheet

I have a macro that has this line: Range("C:C").Find(Date - 1).Select and it worked for months with no problems. Now it can't find Date-1 anymore. I'm guessing it's some sort of setting that changed, any ideas? Thanks! -- ---

$$Excel-Macros$$ Data required please help me

Hi All, Please help me to pull data from sheet 1 to sheet2 in a column by clicking a command button ans should be in column I6 Regards, Rajesh. Nair -- -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ Fwd: Data requeired in sumproduct please help me friends !!!!!!!!!!!!

Hi all, Please find attached workbook for solution of this problem. Thanks & Regards, Gaurav Jain On Mon, Apr 19, 2010 at 4:04 PM, GAURAV JAIN wrote: > Hi all, > > Please find attached workbook for solution of this problem. > > Thanks & Regards, > Gaurav Jain > > On Mon, Apr 19, 2010 at 2:3

Re: $$Excel-Macros$$ Fwd: Data requeired in sumproduct please help me friends !!!!!!!!!!!!

Hi all, Please find attached workbook for solution of this problem. Thanks & Regards, Gaurav Jain On Mon, Apr 19, 2010 at 2:36 PM, Rajesh Nair wrote: > > > -- Forwarded message -- > From: Rajesh Nair > Date: Fri, Apr 16, 2010 at 4:16 AM > Subject: Data requeired please help me

$$Excel-Macros$$ Fwd: Data requeired in sumproduct please help me friends !!!!!!!!!!!!

-- Forwarded message -- From: Rajesh Nair Date: Fri, Apr 16, 2010 at 4:16 AM Subject: Data requeired please help me To: excel-macros@googlegroups.com Hi All, Please help me to pull data from sheet 1 to sheet2 in a column by clicking a command button ans should be in column I6