Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find empty cells in a column then append row that empty cell is in | Excel Programming | |||
Find 1st empty cell within each row | Excel Programming | |||
To find empty cell | Excel Programming | |||
Find Empty Cell in Row | Excel Programming | |||
Please help find the next empty cell | Excel Programming |