VBA - Selecting a Row

E

Elise148

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
 
P

PCLIVE

There are probably many ways. Here are a couple.

Rows("1:1").Select

Range("A1").EntireRow.Select


HTH,
Paul
 
J

JE McGimpsey

One way:

Range("1:1").Select

another:

Range("A1").EntireRow.Select


Another:

Rows(1).Select
 
D

Dave Peterson

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