| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet range copy
I am trying to copy a range across to some worksheets so that these are basically a
replicate of the source worksheet initially. This does effectively what I am after Sheets("Sheet1").Cells.Copy Destination:=Sheets("Sheet3").Cells I just wonder if this is not a hammer to crack a nut. The exact range tranfer required is Sheets("Sheet1").Range("A1:P40").Copy Destination:=Sheets("Sheet3").Range("A1:P40") This however does not copy across column widths etc although it takes all the text and formulas. The first transfer does this however. Is there a tidier way to do this remembering that I will be going through a loop to copy the source to several worksheets. I value any help. Graham |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from a range of worksheet | Excel Programming | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
| Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming | |||
| How? Macro to copy range to new worksheet, name new worksheet, loop | Excel Programming | |||
Threaded Mode
