ActiveCell.Offset for event macro

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

Jeremy

I need to move from the active cell in any row to the cell in column 6 of
the same row.
I know how to use ActiveCell.Offset to move a fixed number of rows and
columns. But I can't figure out how to handle a relative row and absolute
column situtation.
What I need is... ActiveCell.Offset(0,"however many cells there are between
the column I'm in and column 6)
Do I need to create a variable to calculate the number of cells, or is there
a simpler way?
Thank you!
 
Back
Top