I am stumped! How do I make the following generic, so that it chooses the active sheet and not "Sheet1"?
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range( _
"E18:CA18,E29:CA29,E40:CA40,E55:CA55"), PlotBy:=xlRows
I tried :
ActiveChart.SetSourceData Source:=Activesheet.Range( _
"E18:CA18,E29:CA29,E40:CA40,E55:CA55"), PlotBy:=xlRows
but get "object required".
I sure would appreciate any help! Thanks!
Bookmarks