Selecting up to last cell

[twckfa16]

hello -

I have the below and am trying to select and copy up to the last cell. i've seen all kinds of things
but still can't figure it out. I have tried to use range, .range, .select etc but get 'With object not set' type
error messages.

Please Login or Register  to view this content.

So once it finds the workbook named file*, then activate it and select from A2 down to the last cell of data.

Thank you

[PCI]

Try next code.
It works for the active sheet

Please Login or Register  to view this content.

[twckfa16]

Hey PCI -

I tried your suggestion. Got a 'Select method of range class failed' error.

Is there anything else that I may try?

[PCI]

See attached the set of files used to check
Launch the macro from MAIN.xlsm

Please Login or Register  to view this content.

[twckfa16]

PCI - yes that worked for me if you only have data in column A....I added data thru to column J...is there anyway it can find all of this
and select it? Do you have to say select up to column J?

[twckfa16]

hey - not sure how I got it to work but here it is:

Please Login or Register  to view this content.

Thank you

[PCI]

Yes it good but here you are using column R while you were previously asking for J .
Perhaps it would be better to search for the last column or other information to be more flexible.
Perhaps also Rows.count is more that you need, what is you column reference to know the last row?