Macro to insert next template 2 rows after th

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Hi,

I'm trying to create an automated wire frame builder in Excel 2003 that will allow people to show me how they would like webpages to be displayed out. There are 8 different template options to choose from. I want the sheet to be able to insert the first option at "A26" and copy the template froma hidden worksheet (I've managed to get the copy macro working with the following code).

Worksheets("Template Options").Range("A19:O32").Copy _
Destination:=ActiveCell

My problem is, the next time a user clicks a button to insert a template I would like the new table (no data) to be inserted 2 rows below where the first ends and so on. In therory the user can make the page as deep as they like.

Does anyone have any ideas that might help me? I'm very new to all of this VBA stuff so sorry if its a simple thing.

Thanks

Kieran

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Hi

Could you please upload a ZIP file with sample EXCEL files and template WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too