ActiveCell.FormulaR1C1 = "=if(Countif($J:$J,E2)=1,E2,"""")"
My macro keeps throwing an error at this line. Is there an error in the syntax here?
ActiveCell.FormulaR1C1 = "=if(Countif($J:$J,E2)=1,E2,"""")"
My macro keeps throwing an error at this line. Is there an error in the syntax here?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks