Activecell
refers to the current cell in VBA.

ActiveCell.Address
returns the current cell address

ActiveCell.Row
returns the current row and similarly column..

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


"Derrick" wrote:

thanks Jacob
im not quite sure what it all means.. can you explain what is happening with
msgbox, and the other .Column, .Address lines?
.. so i can know how to edit it later


"Jacob Skaria" wrote:

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?