How can I find the address of a cell?

[JCScoobyRS]

In column A, I have two named named cells, one named ASSEMBBEGIN, presently at A73, and ASSEMBTOTAL, presently at A74. Is there a way to be able to find there row position through a macro? I have this macro that needs to be able to look between these two cells no matter where they are as long as there are in column A. Thanks, Jeremy

 

[Ricky Morris]

Try:

Range("ASSEMBTOTAL").Row

 

[JCScoobyRS]

Thanks man.