Select first row of currentregion

  • Thread starter Thread starter vba
  • Start date Start date
V

vba

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
 
Back
Top