How to compare specific cell values in VBA

Question

I have this code:

If cells(3,11).value="c:users\flap-fis.txt"

This condition is getting failed every time either we have file location of or not.

How can I write the code how to check specific cell value with static string?

celles should be cells. Also specify in which worksheet this cell is eg. Worksheets("Sheet1").Cells(3, 11) — Pᴇʜ
– Pᴇʜ, Commented Jun 4, 2020 at 11:16
"Not working" is no error description. Did you specify a worksheet for Cells? Note that your path is missing a backslash ` \` right after c: it should be "c:\users\flap-fis.txt" — Pᴇʜ
– Pᴇʜ, Commented Jun 4, 2020 at 11:20

Dominique · Accepted Answer · 2020-06-04 12:32:36Z

1

Do you know how to debug VBA projects? Best thing to do for such a case is putting a breakpoint on that particular line and use the "immediate" window, where you can ask ? <var> in order to know the value of a variable, as in these examples:

? Cells(3, 11).Value = "c:users\flap-fis.txt"
False

? Cells(3, 11).Value
c:\users\flap-fis.txt
=> Mind the extra backslash, as already mentioned by PEH.

answered Jun 4, 2020 at 12:32

Dominique

17.6k20 gold badges80 silver badges161 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to compare specific cell values in VBA

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related