VBA syntax
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?
|