I am trying to put together a chart that calls to data on a different sheet. There is a macro that inserts a new row so each time new data is inserted it shifts the range down from row 8 to row 9. How can I get the range to start at row 8 even after a new row is inserted? I thought indirect might work but it says the function isn't valid.
Bookmarks