Select to the end of a row based on used column range

Hello all,

Do any of you know the code to select all the cells in a random row of data based on the amount of field names in row1?

Thanks

You could do a CountA on row 1 and that would tell you how many fields it contained.

Please Login or Register  to view this content.

Thanks xladept,

To clarify I'm looking for the column equivalent of the following:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

??

jolivanes and xladept,

I used the CountA to get what I needed done, but I was looking for what jolivanes posted. Now I have both in my VBA inventory. Thanks.

You're welcome and thanks for the rep!