Select First Cell in First Blank Column

[NSTurk725]

I having trouble writing code to perform the following action:

I want to select the first blank cell in the first blank column. I would just look at the column and instruct it to select a given range, but each month the blank column will change (by moving one to the right).

So for example

This Month:
Columns A-Q all have data in it. So, I would need to select cell "R1"

Next Month:
Columns A-R will all have data in it. So, I would then need to select cell "S1"

Etc.

Can anyone help me with some code to auto-detect the blank column and then select that column's first cell?

Thank you for any support.

[jasoncw]

Something like this?

Please Login or Register  to view this content.

HTH,
Jason

[NSTurk725]

That works great! One more question. If I wanted to loop through each cell in that selected blank column and perform a given calculation, how would write that code? I'm having trouble referencing that range.