Thread
:
Copy/Paste problem
View Single Post
#
2
Posted to microsoft.public.excel.programming
merjet
external usenet poster
Posts: 812
Copy/Paste problem
You can copy 'Columns to Columns' or 'Range to Range', but not
'Columns to a Range'.
Try something like this:
Set sRange = WB1.Range("A1:M10")
Set dRange = WB2.Sheets(2).Cells(2, LC)
sRange.Copy dRange
Hth,
Merjet
Reply With Quote
merjet
View Public Profile
Find all posts by merjet