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