Thread: next column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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