Or is the lesson of the day that I cannot use the select method on an object?
I took out the tbl.Select and simple went on to the next line tbl.Copy and
all is well.

Thanks

"ExcelMonkey" wrote:

I am trying to select cell A2 and the SHIFT-CNTL-Right and SHIFT-CNTL-Down.
When I recored the macro the code is as seen below under the comment
'Choose Used Range of target sheet. However when I try to run it, I get an
Run Time Error 1004. ("Method Range of Object _Worksheet failed")


Why is this?

'Select First Cell in Target file sheet
Worksheets("Template").Range("A2").Select

'Choose Used Range of target sheet
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select

Thanks