Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
merging worksheets onto one
Hi. I have several worksheets within in one book. While no single worksheet
is very long, there are about 50 of them. Is there a way to autmate assembling them all onto one worksheet page? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
merging worksheets onto one
Try
http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Doug" wrote in message ... Hi. I have several worksheets within in one book. While no single worksheet is very long, there are about 50 of them. Is there a way to autmate assembling them all onto one worksheet page? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
merging worksheets onto one
Dim sh as Worksheet, sh1 as Worksheet
Dim rng as Range worksheets.Add set sh = Activesheet for each sh1 in Worksheets if sh1.Name < sh.Name then set rng = sh.Cells(rows.count,1).End(xlup)(2) sh1.UsedRange.Copy rng.PasteSpecial xlValues rng.PasteSpecial xlFormats end if Next -- Regards, Tom Ogilvy "Doug" wrote in message ... Hi. I have several worksheets within in one book. While no single worksheet is very long, there are about 50 of them. Is there a way to autmate assembling them all onto one worksheet page? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging two worksheets | Excel Worksheet Functions | |||
merging worksheets | New Users to Excel | |||
merging worksheets | Excel Discussion (Misc queries) | |||
Merging worksheets into one | Excel Discussion (Misc queries) | |||
Merging worksheets | Excel Discussion (Misc queries) |