"Find last row in range" not working with numeric values... VBA

[RobbieC]

Hi there, I have a bit of code that I have just noticed isn't working properly

Dim getLastDescriptionRow As Long
getLastDescriptionRow = Sheets(SheetName).Range("BA17:BF54").Find("*", , xlValues, , xlByRows, xlPrevious).Row

I've looked into it and it fails to pick up the last row if they have numeric values. If the last row has letters in the cells, it picks it up fine...

Why would this not work when the values are just numbers?

If you can point me in the right direction, I'd be very grateful

Thanks

 

[steve the fish]

That had me scratching my head so i tested it and on my machine it works just fine with numbers whether they are created by formula result or just a number in a cell.

 

[RobbieC]

Very strange... I've checked all the cell formatting and they're all set to 'general'...

I have expanded my range to take in the adjacent row which contains letters and not just numbers and it now works ok...

Just can't work out why it's not having it in that range with just the numbers....