Application.WorksheetFunction.Exact

[Azurai]

Hi all..

Is there another option in vba codes to compare 2 cells whether it is "TRUE" or "FALSE"? Because it didn't work if I'm using Application.WorksheetFunction.Exact()

Thank you for your help.

 

[CountTepes]

By true or false, do you mean return true or false if both or either of the cells is true, or true or false when comparing the cells?

 

[Azurai]

Thank you for your fast response!

I mean just like this but in the form of VBA codes, because I want to process using macro

Book1
	A	B	C
1	12345TGU		FALSE
2	34267BGH		TRUE
3	12345TGU
Sheet1

Cell Formulas
Range	Formula
C1	C1	=EXACT(A1,A2)
C2	C2	=EXACT(A1,A3)

 

[Fluff]

Maybe

range("C1")=Range("A1")=Range("A2")

 

[CountTepes]

or with just a formula, in C1 put:

=A1=A2

 

[Fluff]

That is not case sensitive, so does not work in the same way as the EXACT function

 

[CountTepes]

It works with me.

If I type foobar A1 and FOOBAR into A2 and =A1=A2 into C1, it returns TRUE

 

[Fluff]

But what happens if you use exact?

 

[CountTepes]

I see what you mean.

Exact is case sensitive and have become too used to not worrying about the case, as it has never been important.

In VBA code I always use Upper to make sure that all case is the same and irrelevant.

 

[Fluff]

It's one of the differences between Xl & VBA, by and large Xl is not case sensitive, whilst VBA is.