I'm trying to run a macro on multiple excel spread sheets for data ranges that change between sheets. I'm curious how to change two things:
How do I change
To graph for data based on the current sheet I am on not sheet2, and for data range E18:E### where ### is the total number of rows of data in that spreadsheet.Please Login or Register to view this content.
Does anyone know how I can do this?
Bookmarks