Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat copy for indifinate number of worksheets
Hi all! I need some code that will copy a range (incl formatting etc.) of sheet 1, to the exact same range of another workbook's sheet 1. This copy process must repeat for all worksheets in both workbooks even when some sheets are deleted or added in the future. I'm not sure if it will work using the 'For / Next' function. I have attached the example of the code i have so far. The heavily indented mid section is where I need the 'Repeat copy' code. Any help would help! 115: +-------------------------------------------------------------------+ |Filename: Example.txt | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=115| +-------------------------------------------------------------------+ -- ARbitOUR ------------------------------------------------------------------------ ARbitOUR's Profile: http://www.thecodecage.com/forumz/member.php?userid=254 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91316 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indicating Rows to Repeat At Top on all Worksheets Simultaneously | Excel Worksheet Functions | |||
Repeat printing rows in multiple worksheets | Excel Discussion (Misc queries) | |||
How can i repeat certain rows in all worksheets in an excel file | Excel Discussion (Misc queries) | |||
How do I set up a column to repeat on other worksheets in Excel | Excel Discussion (Misc queries) | |||
Modify a Macro to Repeat for all Selected Worksheets | Excel Worksheet Functions |