| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble with copy to newly created sheet
how would i incorporate this into my code?
Dim aName As String aName = Selection.Worksheet.Name .. . . . Sheets(aName).Range(address).Copy On second thought, there is another way. Declare another range variable. e.g. rngC, and set it equal to the cells you want to copy from later. Set rngC = . . . . .. . . . . . . rngC.Copy Destination:= . . . . Hth, Merjet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Refresh data from original worksheet to newly created copy | Excel Discussion (Misc queries) | |||
| using a cell value to name a newly created workbook | Excel Discussion (Misc queries) | |||
| cannot copy newly created files to backup, all existing ok | Excel Discussion (Misc queries) | |||
| Can't find newly created userform | Excel Programming | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
Hybrid Mode
