newbie question. abt cols and rows.

hi,

i often encounter this scenario.

when given a single cell, e.g. B3, i want to select the whole B column,
or the whole of row 3. for example to hightlight the whole row or paste a
formula from the first cell to the whole column.

is the a gd way to do this?
thnks.

Range("B3").EntireRow.Select
Range("B3").EntireColumn.Select

--
regards,
Tom Ogilvy

<a> wrote in message news:[email protected]...
> hi,
>
> i often encounter this scenario.
>
> when given a single cell, e.g. B3, i want to select the whole B column,
> or the whole of row 3. for example to hightlight the whole row or paste a
> formula from the first cell to the whole column.
>
> is the a gd way to do this?
> thnks.
>