ActiveCell.Offset for event macro
 

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!

ActiveCell.Offset for event macro
 

ActiveCell.Offset(0,6 - ActiveCell.Column)

---
frmsrcurl: http://msgroups.net/microsoft.public...or-event-macro

ActiveCell.Offset for event macro
 

ActiveCell.Offset(0,6 - ActiveCell.Column)

---
frmsrcurl: http://msgroups.net/microsoft.public...or-event-macro

ActiveCell.Offset for event macro
 

activesheet.cells(activecell.row,6).select

is another way.


Jeremy wrote:

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!

--

Dave Peterson