Assistance with VB code

[bikerted]

How, in Excel, can I select a complete row from a cell selected in the same row?

 

[SQLBI]

Hi,

Try using;

ActiveCell.EntireRow.Select

Hope this helps.

Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[RobBroekhuis]

If you really want to select it, just use

selection.entirerow.select

Usually, though, there is no need to select anything in Excel. You can do the same with a range object variable:

dim r as range, r2 as range
set r=range("C10&quot
set r2=r.entirerow

By the way, please give your postings a descriptive subject - "Assistance with VB code" doesn't tell us what kind of help you're looking for.
Cheers


Rob

 

[bikerted]

A thousand thanks to you both and what a speedy response!
Best Regards from a more enlightened Bikerted.