| 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) | |||
Hybrid Mode
