Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Assistance with VB code

Status
Not open for further replies.

bikerted

Technical User
Nov 7, 2003
221
GB
How, in Excel, can I select a complete row from a cell selected in the same row?

[dazed]
 
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")
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
[flowerface]
 
A thousand thanks to you both and what a speedy response!
Best Regards from a more enlightened Bikerted.

[bigsmile]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top