Do you know the row number to go to?

Activesheet.cells(###,activecell.column).Select

if you do, change ### to that row number.

Peter Morris wrote:

Peter Morris wrote:

I've recently started doing some Excel programming after a gap
of about 4 years, I find I've forgotten a lot.

What's the syntax for this? The activecell is in a given column.
I want to go to the same column, but a different row, ie a particular
row in a named range "Column_Headings"

to put it another way, what I want to go is go to the column
heading of whichever column I'm in at the moment.

TIA

"Dave Peterson" wrote in message
...
Activesheet.cells(1,activecell.column).Select
or
activecell.entirecolumn.cells(1).Select


No, the cell isn't neccesarily going to be in row 1.
Its going to be above a particular column of figures
but there may be stuff above it.

--

Dave Peterson