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
|