Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying data from one wb to another
i am wondering why this doesn't work
this copies one cell just fine: With Workbooks(fname).Worksheets("data") Range("c4").Value = .Range("c4") End With this copies one cell to the range in c: With Workbooks(fname).Worksheets("data") Range("c4:C9").Value = .Range("c4") End With this does nothing. i was trying to streamline the copying process, but this doesn't work. how would i do this? With Workbooks(fname).Worksheets("data") Range("c4:C9").Value = .Range("c4:c9") End With -- Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying rows of data into new worksheet but placing data into colu | Excel Discussion (Misc queries) | |||
Copying data as static as source data changes | Excel Worksheet Functions | |||
Copying Data into Column with Existing Data | Excel Discussion (Misc queries) | |||
Copying data | New Users to Excel | |||
Copying data down to next dirty cell, then copying that data | Excel Programming |