next column
Like this maybe...
Cells(1, 16).Resize(1, Columns.Count - 15).Find("", LookAt:=xlWhole).Select
If there is any chance all the cells to the end of Row 1 are filled in, then
you will need to include some error trapping since the Find method will
error out there is nothing for it to find.
--
Rick (MVP - Excel)
"oldjay" wrote in message
...
How do I select the 1st row in the next column after 16 that does not
have
any text in row 1?
oldjay
|