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

Activesheet.cells(1,activecell.column).Select
or
activecell.entirecolumn.cells(1).Select

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

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.

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

"Dave Peterson" wrote in message
...
Do you know the row number to go to?


No, that's the point.

To be precise, I know the row number NOW, but
as I develop my code Imight move the cells to a different
location. I don't waant tohard code a specific row
number.

Cells in the row are a named range "column_headers"
I want the current column within that range. Or an
alternative way to do this.

Ahhhh. I missed that part.

with activesheet
.cells(.range("column_headers").row,activecell.col umn).Select
end with




Peter Morris wrote:

"Dave Peterson" wrote in message
...
Do you know the row number to go to?

No, that's the point.

To be precise, I know the row number NOW, but
as I develop my code Imight move the cells to a different
location. I don't waant tohard code a specific row
number.

Cells in the row are a named range "column_headers"
I want the current column within that range. Or an
alternative way to do this.

--

Dave Peterson

Sometimes, I don't read as carefully as I should. This was one (or 4) of those
times.

Dave Peterson wrote:

Ahhhh. I missed that part.

with activesheet
.cells(.range("column_headers").row,activecell.col umn).Select
end with

Peter Morris wrote:

"Dave Peterson" wrote in message
...
Do you know the row number to go to?

No, that's the point.

To be precise, I know the row number NOW, but
as I develop my code Imight move the cells to a different
location. I don't waant tohard code a specific row
number.

Cells in the row are a named range "column_headers"
I want the current column within that range. Or an
alternative way to do this.

--

Dave Peterson

--

Dave Peterson

"Dave Peterson" wrote in message
...
Sometimes, I don't read as carefully as I should. This was one (or 4) of
those
times.

Dave Peterson wrote:

Ahhhh. I missed that part.

with activesheet
.cells(.range("column_headers").row,activecell.col umn).Select
end with


Thanks, that works.

And only after a half dozen messages! <vbg

Peter Morris wrote:

"Dave Peterson" wrote in message
...
Sometimes, I don't read as carefully as I should. This was one (or 4) of
those
times.

Dave Peterson wrote:

Ahhhh. I missed that part.

with activesheet
.cells(.range("column_headers").row,activecell.col umn).Select
end with

Thanks, that works.

--

Dave Peterson