I am able to do this:
but if I want to check a range of cells like so:![]()
If .Range("C5").Value = "AB1234" Then
I get a Type Mismatch Error. What is the correct syntax?![]()
If .Range("C5:C9".Value = "AB1234" Then
I am able to do this:
but if I want to check a range of cells like so:![]()
If .Range("C5").Value = "AB1234" Then
I get a Type Mismatch Error. What is the correct syntax?![]()
If .Range("C5:C9".Value = "AB1234" Then
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks