How to get the row number of new value in a column???

[Guest]

Dear all,

I have a problem, suppose I have column A with the following values:

Column A
-----------

row1 C-15
row2 C-15
row3 C-15
row4 E-06
row5 E-06
row6 E-06
row7 L-04
row8 L-04

I want to get the starting row number of each value.
i.e. the starting row number of "C-15" is 1, the starting row number of
"E-06" is 4 and the starting row number of "L-04" is 7.
I know that I can use a loop and compare the value of next row with the
value of current row, but is there a faster way? Please advise.
Thanks a lot!

Ivan

 

[Leith Ross]

Hello Ivan,

EXAMPLE:
Row = Range("A1").Row
Column = Range("A1").Column

Sincerely,
Leith Ross