First Empty Row
 

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

First Empty Row
 

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


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

.

First Empty Row
 

Thanks Markus, worked like a charm =)

"Markus Scheible" wrote:

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


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

.

First Empty Row
 

Hi Peter,

it was a pleasure to help ;o)

Best regards,

Markus


-----Original Message-----
Thanks Markus, worked like a charm =)

"Markus Scheible" wrote:

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


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

.


.