ActiveSheet.Range("").Select

[Peteor]

I am so close with my macro... This is my last error. I am using the ActiveSheet.Range("").Select method, and it is doing the following:

ActiveSheet.Range("A6").Select 'works like a charm for exactly what I need. I am copy/pasting between files, and using this works.

I would like to use the following:

ActiveSheet.Range("A6:K").Select 'This receives run time error 1004, and I don't know what I am doing wrong.

Basically I want to select the used range of the ActiveSheet starting from (and including) row 6. Any input would be helpful. Thank you.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ange-copy-method-post5219806.html#post5219806

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).