Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I paste data to an variable row?
Any help on this would be greatly appreciated. What I'm trying to do is copy
data from a set range of cells, and paste that data to a variable row & set column. Thank You Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I paste data to an variable row?
Dim VarRow as Integer
VarRow = Some formula to find a row Range("B6:C" & VarRow).Paste "DAVE McClean" wrote in message hlink.net... Any help on this would be greatly appreciated. What I'm trying to do is copy data from a set range of cells, and paste that data to a variable row & set column. Thank You Dave |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I paste data to an variable row?
Dim rng as Range
set rng = worksheets("sheet1").Range("B1:C20") rng.copy Destination:=Worsheets("sheets2"). _ Cells(rows.count,1).End(xlup)(2) -- Regards, Tom Ogilvy DAVE McClean wrote in message hlink.net... Any help on this would be greatly appreciated. What I'm trying to do is copy data from a set range of cells, and paste that data to a variable row & set column. Thank You Dave |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I paste data to an variable row?
you don't say how you select the source that you want to copy.
So... Dim Source as Range Dim Target as Range SET Source = Worksheets("Sheet1").Range("G5:M27") 'or as another example...using a user-selected range 'SET Source = Selection Set Target = Worksheets("Sheet3").Range("C3") ' or if the sourec was defined SET Target = Selection 'now copy the data With Target.Resize(Source.Rows.Count, Source.Columns.Count) .Value = Source.Value End With -- Patrick Molloy Microsoft Excel MVP ---------------------------------- "DAVE McClean" wrote in message hlink.net... Any help on this would be greatly appreciated. What I'm trying to do is copy data from a set range of cells, and paste that data to a variable row & set column. Thank You Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy&paste a variable range rows and colums | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
how do i use the function to copy and paste a determined variable. | Excel Worksheet Functions | |||
Paste a Range from a variable | Excel Programming | |||
How to paste variable value onto a Cell? | Excel Programming |