Insert data into a cell

  • Thread starter Thread starter ljCharlie
  • Start date Start date
L

ljCharlie

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
 
Try using

Activecell.value = 0

or

Activecell.value = 1

depending on what you find.


Brad
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Inserting additional rows and only copying certain columns 1
transformed vloopup 2
Create if partial match then copy and paste data from one cell to another 1
Insert Border 2
Insert Matched Value 7
INsert Formula via Macro 1
Use only cells with data in 7

Back
Top