Hi there,
Sorry for the massive title!
I am using a helper column that works well, but I want it to smarten my find code up to avoid finding the first empty cell in row 1 as often the columns with an empty header still contain data but someone has often been messy when designing a spreadsheet and left a header blank. So I want the find code to avoid blank cells if there is non-blank cells to the right of it. Does anyone know how I would re-wire my code to achieve this?
So in my terrible example below I want my find code to avoid Column C as there is data to the right of the cell
<tbody>
</tbody>
Cheers,
Milos
Sorry for the massive title!
I am using a helper column that works well, but I want it to smarten my find code up to avoid finding the first empty cell in row 1 as often the columns with an empty header still contain data but someone has often been messy when designing a spreadsheet and left a header blank. So I want the find code to avoid blank cells if there is non-blank cells to the right of it. Does anyone know how I would re-wire my code to achieve this?
Code:
Set helper_column = range("1:1").Find("", , , xlWhole, , , False, , False)
So in my terrible example below I want my find code to avoid Column C as there is data to the right of the cell
A | B | C | D | E | F | |
1 | Sunny | Rainy | Cloudy | Stormy | This is the cell i want to reference | |
2 | 5 days | 1 day | days present | 3 days | 0 days |
<tbody>
</tbody>
Cheers,
Milos