ConditionalFormat Offset Arg1 in match function.

[soidog]

Hi all,

Syntax
expression.Match( Arg1, Arg2, Arg3 )

In code below I have one of three expressions just to make code easy to read.
Arg1=C42. After first loop Arg1 must be C60 etc etc.
How to change Arg1 in match function?

Please Login or Register  to view this content.

Any help will be greatly appreciated.
Thanks!

[Fluff13]

How about

Please Login or Register  to view this content.

[soidog]

How about

Please Login or Register  to view this content.

Hello Fluff13
Thank you for answer.
I changed to your solution and that gave me a Run-time error 5: "Invalid procedure call or argument"
I then changed all commas to semi-colons which resulted in all cells in rng30 became formatted according to code.
FYI, each cell in rng30 are formatted as "General" and contains first name, space and surname. Column "A" in "Sheet5" also formatted as "General".
I tried with istext but then nothing happens. Also noticed that "isnumber" doesn't change to "IsNumber".
Any idea of what's wrong?

Thanks in advance

[Fluff13]

Can you supply a copy of your workbook, as that makes it a lot easier to debug.

[soidog]

Hello Fluff13
Thanks alot for your input. Your solution with range = " & rng31.Address & " made me think a bit different and then I solved the problem with this solution.

Please Login or Register  to view this content.

It seems to work but if you can see anything not so good with code, I would appreciate if you point it out.

Thanks

[Fluff13]

That looks fine & glad you sorted it.