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!

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!

Select first row of currentregion
 

Thank you Nick!

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

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