Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - Selecting a Row
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - Selecting a Row
There are probably many ways. Here are a couple.
Rows("1:1").Select Range("A1").EntireRow.Select HTH, Paul "Elise148" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - Selecting a Row
One way:
Range("1:1").Select another: Range("A1").EntireRow.Select Another: Rows(1).Select In article , Elise148 wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - Selecting a Row
Another way........
ActiveCell.EntireRow.Select Vaya con Dios, Chuck, CABGx3 "Elise148" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - Selecting a Row
one mo
rows(1).select Elise148 wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - Selecting a Row
THANKS everyone! :)
Elise "Dave Peterson" wrote: one mo rows(1).select Elise148 wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting cells without certain value | Excel Worksheet Functions | |||
Selecting data | Excel Worksheet Functions | |||
ytd sum by selecting month | Excel Worksheet Functions | |||
Selecting every odd row | Excel Discussion (Misc queries) | |||
VBA Code for selecting row | Excel Discussion (Misc queries) |