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

--
regards,
Tom Ogilvy

<a wrote in message ...
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.