Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run a macro from a cell reference
if i have the name of a macro in cell A1, how can i run
it by referencing the cell address? supposing the value of A1 will change. like if i clicked a CommandButton and cell A1 said "PrintSheetOne" it would run the macro PrintSheetOne. and likewise for two and three etc. i have : Private Sub CommandButton4_Click() Run "(Sheets(Report).Range(A1))" End Sub where have i gone wrong? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro using a cell reference | Excel Discussion (Misc queries) | |||
Cell Reference Macro | Excel Discussion (Misc queries) | |||
cell reference in macro | Excel Discussion (Misc queries) | |||
variable cell reference in a macro | Excel Discussion (Misc queries) | |||
Chnaging Cell reference through macro | Excel Discussion (Misc queries) |