VBA - Selecting a Row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to select a row in VBA...I cannot figure out how to do
this...does anyone know a code I can use to select a row in a worksheet?

I'd appreciate any help you can offer! Thanks!

Elise
 
There are probably many ways. Here are a couple.

Rows("1:1").Select

Range("A1").EntireRow.Select


HTH,
Paul
 
One way:

Range("1:1").Select

another:

Range("A1").EntireRow.Select


Another:

Rows(1).Select
 
Another way........

ActiveCell.EntireRow.Select

Vaya con Dios,
Chuck, CABGx3
 
one more:

rows(1).select

I am trying to select a row in VBA...I cannot figure out how to do
this...does anyone know a code I can use to select a row in a worksheet?

I'd appreciate any help you can offer! Thanks!

Elise
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA for deleting Selected Row 0
Error Message in VBA 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel VBA 1
vba powerpoint pasting named shape in selected named slides 0
Excel VBA 0
VBA to select all cells with content 2
Cannot select rows in VBA 1

Back
Top