how can I return the active row and active column?
 

Thank you Jason.

If the Help facility within Excel was only so clear !!!


"Jason Morin" wrote:

ActiveCell.Row
ActiveCell.Column

HTH
Jason
Atlanta, GA

-----Original Message-----
Need to be able to identify exact where user is in
spreadsheet by row &
Column. Macro inserts row above, but I need to be able
to format cells
within new row. such as merging cells in the new row,
drawing a box around
new merged cell, copying formulas, etc.

Any help would be appreciated.

.