VBA reading a cell and giving different value than what is in the cell

[JoeKerr99]

Hi folks. I've come across a strange problem and I need some help. I'm new to VBA coding but most problems I can work out logically. This, however, seems to just be an error and my coding seems correct.

I have a list (on page called "Last Calcs"), that list is imported to "Final Page" and put in descending order (by 'rank') allowing me to see what 'coin' preforms the best (these are a series or other calculations throughout the sheet, its a sheet for tracking Cryptocurrencies). This is the formulae I use: =SORTBY('LAST CALCS'!$H$3:'LAST CALCS'!$L$14,'LAST CALCS'!$H$3:'LAST CALCS'!$H$14,-1)

So, on the two sheets each coin is followed by a command (Hold, Sell, Buy, Stablecoin). My problem is that the sheets are saying one thing but VBA reads another and acts accordingly (as in quite literally its reading 'hold' as 'sell' and I don't know why!). I've even gone so far as to have VBA read the cell, write it to another cell and compare the two, which it declares as 'FALSE' (or not equal)

Any help would be MOST appreciated! Usually I can spot bad logic or a typo, for the most part this works, but once in a while its just wrong and I don't know why!

[6StringJazzer]

You are asking us to solve a VBA problem without showing us the VBA with the problem. Also, you could also have an issue in the data, which can't be determined by looking at a screen shot.

Please attach your actual file, see yellow banner at the top of the page.

[JoeKerr99]

Its the outputs that are the problem, not the code per se, the cell says one thing and VBA is reading another.

I'll post the file and a splurb on what's going on...