I have a macro that I need to run continuously until there is no more data in the up and coming column. I have a macro that precedes this one, which adds 6 columns and fills it with data. I have a macro written that adds the data for the first group of six columns, and I need that to loop as long as there is data in the next six column until there is no more data in any of the columns.
I'm looking for something that I would put around the macro, something along the lines of;
I believe this would be the best way for the macro to run, or would I just include the Sheets and application run inside of the Do...Loop.
Thanks for the help
Bookmarks