Amend VBA Range to exclude header row

Amend VBA Range to exclude header row

Hi,

I have the following piece of VBA code i.e.

Please Login or Register  to view this content.

Range("T2:AT999999").Select

Please Login or Register  to view this content.

Can anyone please advise how to amend the VBA code to select the complete range i.e. all the cells in the columns ‘A’ thought to ‘AT’ (i.e. with the exception of the headers i.e. ‘T1’ to ‘AT1’)

Any assistance received would be greatly appreciated

Many thanks in advance

Regards

Rob

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.