Msgbox Activecell.Row
Activecell.Column
Activecell.Address

If this post helps click Yes
---------------
Jacob Skaria


"Derrick" wrote:

how do i select the current cell im in .. in vba
lets say, im in B3 and edit the value - im working on a code that will say:
- in Row 3, check and recalculate D3 if necessary(which uses VBA to create a
validated list based on a loop... so i can't just use formulas)
if in row 4, check and recalculate D4.

so.. i need to be able to get the number of the row im in.. so i can set it
to a variable and go from there

any help?