How to set ActiveCell to a new column?

I want to set the activecell to the same row it currently is and set
the column to "B". The activecell can be in any column. I looked
into using "offset", but it would take a bit more (calcing if a
negative or positive offset) than I would suspect. Is there something
like "Set Activecell.Column = "B""?

How do the pros do it?

Carl

Hi,
try this....

Range("B"&Activecell.Row).Select

Hth
OJ

cells(activeCell.row,2).Select

--
Regards,
Tom Ogilvy


"Carl" <CarlM@hotmail.com> wrote in message
news:o6ii31hcifgsicubdnr373d3v9gsgpgc9a@4ax.com...
>
> I want to set the activecell to the same row it currently is and set
> the column to "B". The activecell can be in any column. I looked
> into using "offset", but it would take a bit more (calcing if a
> negative or positive offset) than I would suspect. Is there something
> like "Set Activecell.Column = "B""?
>
> How do the pros do it?
>
> Carl
>

Thanks. Works as desired.

Carl

On 17 Mar 2005 01:12:21 -0800, "OJ" <oferns@gmail.com> wrote:

>Hi,
>try this....
>
>Range("B"&Activecell.Row).Select
>
>Hth
>OJ

Thanks. Works as desired. I can see from previous poster there are
several ways to code a line (AKA - skin a cat).

Carl


On Thu, 17 Mar 2005 08:07:48 -0500, "Tom Ogilvy" <twogilvy@msn.com>
wrote:

>cells(activeCell.row,2).Select

some approaches are more robust than others. for example, cells can take a
number variable in both arguments

i = cells(activecell.Row,256).End(xltoLeft) + 1
cells(activecell.Row, i) = "Something"

would put something in the next available column of the row of the
activeCell

as an example.

--
Regards,
Tom Ogilvy

"Carl" <CarlM@hotmail.com> wrote in message
news:lsqj3159n0h5n9obgc2s1u9b0h9vnn21a5@4ax.com...
> Thanks. Works as desired. I can see from previous poster there are
> several ways to code a line (AKA - skin a cat).
>
> Carl
>
>
> On Thu, 17 Mar 2005 08:07:48 -0500, "Tom Ogilvy" <twogilvy@msn.com>
> wrote:
>
> >cells(activeCell.row,2).Select
>