How to change macro so it performs actions on ACTIVE sheet?
Hi,
I want to create a macro that I can run on various sheets. All these sheets
have the same format but different data. I created the macro and opened it
with microsoft visual basic. The problem is the '=Sheets()' command that
selects the sheet that i used to record the data. How do I change it so it
just runs on the active sheet?
ActiveChart.SetSourceData Source:=Sheets("S&P").Range("A4:A13,C4:C13"),
Thanks
|