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.
[Blocked Image: http://icons.iconarchive.com/icons/double-j-design/ravenna-3d/24/File-Copy-icon.png]
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!