Range Copy
 

Hi,

I'd appreciate some help on copying Ranges.

I have a workbook that contains one sheet. I'd like to copy that
sheet, except the first three rows, to the second row (A2) in another
sheet in a different workbook.

I think I need something like:

....With the source sheet active...

Rows("1:3").Select
Selection.Delete Shift:=xlUp

wkbSource.Sheets(1).Range(UsedRange).Copy _
wkbTarget.Sheets("Timesheet Actuals").Range("A2")

but I think I've got the use of UsedRange wrong as this errors...!


TIA.

Jon C

Range Copy
 

Forget it...... I should be shot for stupidity.....!

wkbSource.Sheets(1).Used*Range.Copy _

Jon C