Extracting Column address only

[aa2000]

Hi folks

As part of my macro I have the following code:

x = Range("A1").End(xldown).Select.Address 
For a = 3 To x

If... Then...

Next a

However the value of x is the full cell address (including column and row).
Can this be changed to get x = row number?

Cheers
</pre>

 

[Rick Rothstein]

However the value of x is the full cell address (including column and row). Can this be changed to get x = row number?

If x is a cell address, then Range(x).Row would be its row number... so that is what you would use in place of the x in your For statement.

 

[Jon von der Heyden]

x = Range("A1").End(xldown).[B][COLOR="Red"]Row[/COLOR][/B]

 

[aa2000]

Thanks guys, the .Row command was what I was looking for.

Cheers