Select the active cell's entire row


Posted by Ian Bartlett on November 25, 2001 11:46 PM

Does anyone know the macro code to select the entire row that contains the active cell (ie. if cell C12 is active, select all of row C)

Many thanks,

Ian

Posted by Ivan F Moala on November 26, 2001 1:06 AM

Rows(ActiveCell.Row).Select (NT)

Posted by kristel keppens on November 26, 2001 1:12 AM

ActiveCell.EntireColumn.Select



Posted by Ian Bartlett on November 26, 2001 4:49 AM

That was it, thanks Kristel, worked a charm.

MVG,

Ian