Hello,
I have a nice macro that changes one column into several columns. The problem is I have to step into the macro to alter the number of rows the column goes into. The value I want to change in the seventh for down in the below macro (No_row = 40)
Is it possible to add a number box in the sheet that alters the value without stepping into the macro? It would be great to have it in the quick access toolbar but not essential.
Any help would be greatly appreciated.
Please Login or Register to view this content.
Bookmarks