I have a cell in range A, containing Account 199. I am using .Cells(rownum,1) to find a string.
If ActiveWorkbook.Worksheets("Startsheet").Cells(rownum, 1).Value = "Account 199" Then
In a particular sheet, in the actual postion of rownum, comparison using IF is not working and job is not done, but, when a separate row is introduced above the actual position then the above comparison using IF is working properly.
Tried by replacing .Value with .Text both with Range and Cells function, but no result.
Any suggestions please.