Find first Empty Cell in a row
 

I have a spreadsheet where each row has a varying number filled cells. I
want to find the first empty cell in the row. I tried searching for the
first cell with a value equal to 'Empty'. However, this sees a 0 and an
empty cell as the same. How do I find the cell that is empty (not populated
with a zero value)?

Find first Empty Cell in a row
 

FirstBlankCellInColumnC = Cells(1, "C").End(xlDown).Row + 1

--
Rick (MVP - Excel)


"Scott R" <Scott wrote in message ...
I have a spreadsheet where each row has a varying number filled cells. I
want to find the first empty cell in the row. I tried searching for the
first cell with a value equal to 'Empty'. However, this sees a 0 and an
empty cell as the same. How do I find the cell that is empty (not populated
with a zero value)?