Range with multiple rows and Columns.

Im using the following range to copy data from Column A (from rows 3 on the the last row). How can I include Columns B and C into this range also, but still using Column A to find the last row?

Please Login or Register  to view this content.

Thanks Norie.
How can I then tell it to occupy cells A3 to C3 down. I was using the following code when it was just one Column:

Please Login or Register  to view this content.

Im basically trying to copy data from one workbook (Dimmed wb) to another (Dimmed mybook). The sheet is called "Users" on both workbooks. Im trying to copy the data in Column A, B & C from rows 3 on from workbook wb to the exact same corresponding cells on workbook mybook.

Please Login or Register  to view this content.

AB33 I believe that will just copy the data in those cells, I'm looking to then paste it into the workbook mybook, sheet 'Users' into the same Columns A, B and C in the next available row from 3 on.

That code gave me the following error:
run time error '1004'
Copy method of range class failed

I also tried the following:

Please Login or Register  to view this content.

Which didn't produce any errors, but it didn't copy the data either.