Find first Empty Cell in a row

S

Scott R

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)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Count latest number of continous not-empty cells in a row. 11
VBA set thick borders around non empty cells in range 0
Search for empty cells and move cells next to 10
Dynamic Offset from an Application.Goto cell = Date or Time 10
Find Empty Cell 3
Macro to "find" the next empty cell in a range 2
Help finding first empty cell in column 1

Top