Strange xldown result

Hi all,

In my code i am using xldown to move to the next cell that is non blank.

When i run this code:

Table is A1:D100

I am looking for the next cell in Column A (After ActiveCell) that is Non Blank.

A11 = String
A12 = String
A13 = String etc
A22 = String

When i run this using A11 as Activecell, It finds the next Non Blank/Non Empty Cell as A15 for example.. when it should be A12.

The Line of Code is:

Please Login or Register  to view this content.

Does anyony have any idea why???

Regards

JRidge

For some reason it sees the cells A12, A13 and A14 as Blank/Empty even though they have something in..

And i don't know why??

How would i find the next cell that is Non Empty then

I want it to find A12 as it is the next cell that is not empty

I want it to skip any Blank cells and find the next Non Blank...

So if:

A11: Active cell
A12: Blank
a13: Blank
A14: String

It would find A14

But if

A11: Active Cell
A12: String

It would find A12