Cells(i,j).Value not able to compare strings | بلاگ

Cells(i,j).Value not able to compare strings

تعرفه تبلیغات در سایت

آخرین مطالب

امکانات وب

Vote count: 0

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 
End If

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.

asked 29 secs ago
Krishna Pavan

نویسنده : استخدام کار بازدید : 0 تاريخ : يکشنبه 11 شهريور 1397 ساعت: 17:35