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