View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Greg is offline
external usenet poster
 
Posts: 331
Default 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.

.