First Empty Row

[Guest]

Hello all,
I am trying to get my database to use the first empty row it "should" find.

The thing is it all works great until I delete the contents of a row (not
the row itself).
IE:
A2:data
A3:data
A4:empty
A5:data
A6:data

It still refuses to see this empty row, and just goes to the first empty
row under my data.

So, is there a way to make Excel see an empty row, even if it's in the
middle of other data. Or scan from the top down, and take the first row it
sees has nothing in it.

Regards
Peter

 

[Markus Scheible]

Hi Peter,

-----Original Message-----
Hello all,
I am trying to get my database to use the first empty row it "should" find.

..Range("A2", "A6").SpecialCells(xlCellTypeBlanks).Cells
(1).Row

gives you the first row with empty cells - in your example
it would be "4"


Best

Markus

 

[Guest]

Thanks Markus, worked like a charm =)

Hi Peter,



..Range("A2", "A6").SpecialCells(xlCellTypeBlanks).Cells
(1).Row

gives you the first row with empty cells - in your example
it would be "4"


Best

Markus

 

[Markus Scheible]

Hi Peter,

it was a pleasure to help ;o)

Best regards,

Markus