Application.Run "macro_" & Range("A1").Value

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"zephyr" wrote in message
...
This week is week # 45.

I have 52 macros on a worksheet. Each one selects data for a particular
week
when a button is pressed. I would like to eliminate the buttons and have
the
macro start when the particular week# is typed in the cell.

If a particular week # is typed in a cell how do I get the macro to start
for the week number selected. The week number may range from 1 to 52.

Many thanks in advance.