Copy range based on cell value

I have the code to copy a range from a sheet.

Please Login or Register  to view this content.

The range on the sheet is a sign up form for 30 names.

If I change the number (in the area in red), I can control how many times it copies the range. I'd like to be able to enter a number (Like RSVP total) in a cell on another sheet, click a button, and it copies the range so there are enough sign up forms to sign in.


I'm still muddling through all this VBA stuff and I thank everyone here that has been helping me.

Also, does anyone know if it's possible to copy ranges from hidden sheets? Like maybe pull a bunch of forms together to make a packet but not have all the tabs ( I have over 30) at the bottom of every form/ document?

Thanks.

Hi jumonjii,

If I understand well, something like that might work.
Make sure to refer to the range by using the sheet name.
Also, no need to use .Activate as it slows down your code.

Please Login or Register  to view this content.

So this will copy the range A1:E1 in "Hidden Sheet" to "Visible Sheet", the number of times iti is written in cell A1 of "Other sheet"