Hi everyone,
I wrote this piece of code [tell me where I messed up if I did here - so far it works good]:
What I have on sheet one is x number of records starting from row 2 to i. On A2:A? I have numbers from 1 to ?; on A1 I have Max of Col A, so that second part of the code above can work. The first part just deletes everything except sheet1 and 2 in case someone presses the button to generate more than once. My question is: Is it possible to rename all those created sheets starting from 1 to ? (which is the value on A1) in ascending order?.
Please look at the attached if needed.
Cheers,
Bookmarks