I have a macro program to find a match. But here's what I want to do an
couldn't figure out how. The macro goes into the two columns and find
match. If it finds a match, I want to insert a 0, if not, insert a 1 i
that cell. Can anyone show me how to insert and 1 and 0 in this case?

Any help is appreciated.

ljCharli

--
Message posted from http://www.ExcelForum.com

Try using

Activecell.value = 0

or

Activecell.value = 1

depending on what you find.


Brad
-----Original Message-----
I have a macro program to find a match. But here's what
I want to do and
couldn't figure out how. The macro goes into the two
columns and find a
match. If it finds a match, I want to insert a 0, if
not, insert a 1 in
that cell. Can anyone show me how to insert and 1 and 0
in this case?

Any help is appreciated.

ljCharlie


---
Message posted from http://www.ExcelForum.com/

.