Macro to regonize selected row

[srvcjlo]

I would like to select a row before running a macro and the either the row will be remain selected or will be automatically reselected after the macro stops. Is there any code to regonize the area/cell/row are selected as it runs? Thank.

 

[SydneyGeek]

One way to do it, which will work if you are not inserting or deleting rows in the macro...

  Dim Rw as Long
  Rw = ActiveCell.Row
  'rest of macro in here, then...
  Cells(Rw,1).EntireRow.Select 'to select the whole row, or
  Cells(Rw,1).Select 'to select column A in the initial row

Denis