Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: James Rivera   on Nov 18 In MS Office Category.

if statment


  
Question Answered By: Aiko Suzuki   on Nov 18

You may need to change the statementa s follows:

ActiveCell.FormulaR1C1 =
"=IF(AND(RC[-1]=R[1]C[-1],RC[-2]=R[1]C[-2]),""duplicate"","" "")"

If Active Cell is F4 and run this code, then VBA will output this formula:
=IF(AND(E4=E5,D4=D5),"duplicate"," ")

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on if statment Or get search suggestion and latest updates.

Related Topics:

Tagged: