Hello All,
I haven't posted in a while as I try to be relatively self reliant and solve my own issues, but this one would save me about a day of copy paste so i'm asking for help. I have a series of hide/unhide functions for different rows that currently take the form of one command button and two shapes (with bound macros) per 11 rows. This is for a survey/analysis form and so I may need as many as 250 sets of 11 rows. I already have all of the macros generated using as little changing variables as I can so that I just change one variable for each iteration, but the copying of the actual command button and shapes for each of the 250 would be very tedious. The second part is that I can hit ctrl+v just as fast as the next guy, but having them located properly upon pasting would be a great feature to have in the code.
To summarize, I have a command button is rows 2, 13, 24, a shape bound to similar macros in rows 3, 14, 25, and a second shape with another type of macro in rows 4, 15, and 26. This makes up three (3) iterations of my inspection form, and to cover the scope of what I do 250 is the number I am looking for in total. If my math is correct that would mean the last set of command button and shapes would occupy rows 2,741, 2,742, and 2,743. I would not like to do this by hand. If anyone has a solution please let me know. I have attached my spreadsheet for your perusal and/or use.
Thanks,
DarkF1ame
Book2.xlsm
Bookmarks