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!