Select Range in Active Row

**[email protected]** · 12-09-2011, 01:48 AM

Good day, Gurus! It's been awhile.

I'm sure this has been answered, but my search couldn't provide an answer.

All I want to do is selct a row, and then copy cells A to AP in that selected row.

Tried this, it didn't work.

Please Login or Register  to view this content.

Thanks in advance for any help you can offer.

**rscsmith** · 12-09-2011, 02:12 AM

Hi Hutch

Try:

Please Login or Register  to view this content.

A neater version is:

Please Login or Register  to view this content.

If you don't need to refer to AR again later, you don't need it at all. You can go straight to:

Please Login or Register  to view this content.

Resize(1,42) is because AP is the 42nd column.

Remember in your code that AR is a Range, not a string. To use its row number as you originally intended you would need to use AR.Row

Best regards, Rob.