| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax error?
try this
ActiveCell.Formula = "=if(Countif($J:$J,E2)=1,E2,"""")" -- Gary "cooldyood" wrote in message ... 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? -- cooldyood ------------------------------------------------------------------------ cooldyood's Profile: http://www.excelforum.com/member.php...o&userid=35611 View this thread: http://www.excelforum.com/showthread...hreadid=570597 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| runtime error: syntax error or access violation | Excel Programming | |||
| runtime error: syntax error or access violation | Excel Programming | |||
| variable not declared error & syntax error | Excel Programming | |||
| Syntax Error help | Excel Programming | |||
| Syntax Error Runtime Error '424' Object Required | Excel Programming | |||
Threaded Mode
