jessieo387
New Member
- Joined
- Jun 10, 2009
- Messages
- 40
I want to run a macro called Macro1 on about 40 different worksheets in the same workbook. I wrote this macro to do that:
Sub Run_all_solver_macros
Call Macro1
End Sub
Its not working I think because this macro isn't need on every worksheets, how do I make this refernece only to the worksheets it needs to run on?
Thanks!
Jessica
Sub Run_all_solver_macros
Call Macro1
End Sub
Its not working I think because this macro isn't need on every worksheets, how do I make this refernece only to the worksheets it needs to run on?
Thanks!
Jessica