Macro to insert next template 2 rows after th

Closed
Kieran - Aug 9, 2010 at 05:53 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 9, 2010 at 02:11 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 9, 2010 at 02:11 PM
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
0