Forum Discussion

awhawh's avatar
awhawh
Contributor
8 years ago

Excel comparison cell by cell using Text method returning hash characters

Hi,   I'm trying to compare two excel files cell by cell and then calling aqString.Compare to do the actual comparison on the text returned. I've got the mechanism working; however, the 'Text' meth...
  • shankar_r's avatar
    8 years ago

    Hi,

     

    Are you using which method to get the cell value using Range("A1") or Cell(1,1)? 

     

    both has property called Value2 or Value_2 to get cell value can you try these.

     

    If still face any issues, post your code here.