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
 
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
 
Back
Top