i have a range of rows that contains text. I want to check if a string exists within this range. but i keep getting errors
what is proper syntax?
Rng = Range("a1:a200")
if Instr(Rng, "All Formulas") then
if Instr(Rng.text, "All Formulas") then
if Instr(Rng.value, "All Formulas") then
none work. if i try to print the range i get
Debug.Print (Rng.Text) = Null
Debug.Print (Rng.Value) = type Mismatch
what is proper syntax?
Rng = Range("a1:a200")
if Instr(Rng, "All Formulas") then
if Instr(Rng.text, "All Formulas") then
if Instr(Rng.value, "All Formulas") then
none work. if i try to print the range i get
Debug.Print (Rng.Text) = Null
Debug.Print (Rng.Value) = type Mismatch