have two named ranges "NameA" and "NameB"
When I loop though "A" and test for values how do I address the same row in "B"
Example
"NameA" "NameB"
1 text1
2 text2
3 text3
Something like:
For Each MyRange in Range("NameA")
if MyRange...
Trying to put together my 1st DB.
The objective is to see reports showing differences between Satellite television providers, to answer questions like what channels does one gain or lose when switching providers and or channel packages. I also am going to include a lot of supporting data like...
=DCount("[Disposition]","History Query","[Disposition]='Wrong Number'")
this works with [Disposition] = Wrong Number
but what about when [Disposition] = "Wrong Nmber"
or simply put how do I compare when Quotes are part of the text value?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.