Hi!
Please help me with a code that runs a macro on certain sheets. I have a list of sheetnames in my first sheet and want that when I run this vba code/macro it runs on each of the sheets I have selected/highlighted out of the sheetnames I have listed on that first sheet.
The code I currently am using I have put into each sheet but that has become to cumbersome.
Here is the code I am using.
Code
Private Sub Worksheet_Calculate()
Application.EnableEvents = False
Range("D4").GoalSeek Goal:=0, ChangingCell:=Range("C13")
Application.EnableEvents = True
End
Is this possible?
All help is appreciated. Thanks!
-Sky