NULL cells and cells with data

[bishoposiris]

I know this will tell me how many rows I have:

Please Login or Register  to view this content.

But I have a column of data with empty cells interspersed. How do I find the first cell in the column with data in it?

[Leith Ross]

Hello bishoposiris,

To find the first cell in a column with data on the active sheet :

Please Login or Register  to view this content.

[bishoposiris]

We're close. This is my code currently:

Please Login or Register  to view this content.

Here is my range G2:G15 (EditLastRow is 15 in this case):

Please Login or Register  to view this content.

Your code sets EditDateCell to 2/18/2014 18:17 which is the last row. How do I make it set EditDateCell to 2/18/2014 1:00 which is the first row?

[Leith Ross]

Hello bishoposiris,

Sorry, I forgot to set the starting point to the last cell. The next cell will then be the first con empty cell.

Corrected Code

Please Login or Register  to view this content.

```

[bishoposiris]

Super! One last piece...

What's the correct syntax to make this work:

Please Login or Register  to view this content.

I've tried:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

but I keep getting errors. EditDataCell is

Please Login or Register  to view this content.

[Leith Ross]

Hello bishoposiris,

This should work.

Please Login or Register  to view this content.