Have a working macro work on a different sheet in the same workbook

[steven_e]

I have a macro that works. What do I need to add to make it work on a different sheet in the same workbook

Sub FillDown()

' FillDown Macro

' All my macro is here and it works
' my code here
' my code here
' if I am on the same sheet as the macro button

End Sub

The button to run the macro is on: Sheet1 (Cover)
I want to click the macro button and ONLY have it run on: Sheet2 (Savings)

[Norie]

Add worksheet references for all the ranges you refer to in the code.

By the way, FillDown is a VBA method so it might not be a good idea to give your sub the same name.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.