Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to copy a range of cells in to a new spreadsheet.
I have following code, but it does not work for variable length cells Dim wsSource wsDestination As Worksheet Dim rFrom, rTo As Range Set wsSource = Sheets("SHEET1") Set wsDestination = Sheets("SHEET2") Set rOld = wsSource.Range("A1:C15") Set rNew = wsTarget.Range("A1") rOld.Copy Destination:=rNew Number of ciolumns is known, but I would like to change the number of rows. Are there any easy way to programming change row number of rOld? Any information is great appreciated, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy cells to variable number of rows | Excel Discussion (Misc queries) | |||
Copy Cells - using Variable | Excel Discussion (Misc queries) | |||
Copy only Visible Cells of a Variable Range... | Excel Programming | |||
copy sheets of cell length is more than 255 char | Excel Programming | |||
Parsing data - variable length cells | Excel Programming |