Dim myMacCell as range
Set myMacCell = worksheets("sheet9999").range("a2")
'some testing to see if it's ok should go here
if it_is_ok then
application.run mymaccell.value
else
beep
end if
Cathy wrote:
A1 contains a number that changes randomly from 1 to 100
a2 reads =concatenate("Macro",A1)
Therefore A2 equals Macro1 when A1 is 1
I have written 100 macros for each of these values as I could not figure out
another way to do this. (still a little new to VB)
How do write a macro so that when it runs it refers to the cel A2 to see
which macro it is supposed to run
Thanks in advance
C
--
Dave Peterson