I have an Excel sheet and I’d like to implement the following logic:
If A2 = “Dog” AND A3=“Cat”
Then, do something…
How would I go about doing this with a FOR EACH ROW loop?
This was my thought, but, its not working:
FOR EACH ROW
READ CELL (“A” + rowcounter.tostring) (say this is A3)
READ CELL (“A” + rowcounter.tostring - 1) (say this is A2)
No matter what I try for A2, I always get a cannot convert “String” to “Double” error.
Do you know what the correct way to reference the previous row would be?