Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select first row of currentregion
Hi all,
Could anyone perhaps help me with the following: I am trying to select the first row of my file using visual basi. But I would like to select only the cells of the first line in the currentregion, that is the cells that contain a value. Is there some simple code to do this? Thanks a lot! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select first row of currentregion
There's probably a better way but:
ActiveCell.CurrentRegion.Range(Cells(1, 1), Cells(1, ActiveCell.CurrentRegion.Columns.Count)).Select NickHK "vba" wrote in message oups.com... Hi all, Could anyone perhaps help me with the following: I am trying to select the first row of my file using visual basi. But I would like to select only the cells of the first line in the currentregion, that is the cells that contain a value. Is there some simple code to do this? Thanks a lot! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select first row of currentregion
Thank you Nick! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select first row of currentregion
Another way:
ActiveCell.CurrentRegion.Rows(1).Select vba wrote: Hi all, Could anyone perhaps help me with the following: I am trying to select the first row of my file using visual basi. But I would like to select only the cells of the first line in the currentregion, that is the cells that contain a value. Is there some simple code to do this? Thanks a lot! -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select first row of currentregion
Knew there must a shorter way.
NickHK "Dave Peterson" wrote in message ... Another way: ActiveCell.CurrentRegion.Rows(1).Select vba wrote: Hi all, Could anyone perhaps help me with the following: I am trying to select the first row of my file using visual basi. But I would like to select only the cells of the first line in the currentregion, that is the cells that contain a value. Is there some simple code to do this? Thanks a lot! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select a range in a column in currentregion | Excel Programming | |||
currentregion | Excel Discussion (Misc queries) | |||
CurrentRegion less one Row | Excel Programming | |||
CurrentRegion | Excel Programming | |||
CurrentRegion Failure. Please help! | Excel Programming |