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!

There's probably a better way but:
ActiveCell.CurrentRegion.Range(Cells(1, 1), Cells(1,
ActiveCell.CurrentRegion.Columns.Count)).Select

NickHK

"vba" <macaroni_elleboogje@hotmail.com> wrote in message
news:1153300786.676593.320670@h48g2000cwc.googlegroups.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!
>

Thank you Nick!

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

Knew there must a shorter way.

NickHK

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:44BE20F1.11213837@verizonXSPAM.net...
> 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