View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_699_] Rick Rothstein \(MVP - VB\)[_699_] is offline
external usenet poster
 
Posts: 1
Default Macro based on Cell Value

Can you explain what "run Macro in D1" means? Do you mean you have several
different macros, one for each cell in Column D? Or do you have a single
macro that you want to run using the value contained in the cell in Column D
corresponding to the cell in Column A with the "Y" in it? If the first one,
what are the names of your macros. If the second one, posting your code
would probably be useful. Also, what is supposed to happen if more than one
cell in Column A has a "Y" in it? Finally, how far down Column A is your
"Etc." supposed to mean?

Rick


"NPell" wrote in message
...
Hello, i have seen some macros but not exactly what i need.

I want the macro to run based on the value of a cell.
IE
A1 = "Y" .. Run Macro in D1
A2 = "Y" .. Run Macro in D2
....
A7 = "Y" .. Run Macro in D7

Etc.

How can this be done?

Thanks