compile error problem
 

I keep getting a compile syntax error on this line of my macro.

ActiveCell.FORMULA = "=IF(B3<\"\",(J" & i & "*R" & i & ")+S"
i,\"\")

what am I missing

--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=39328

compile error problem
 

Do you intend this?:

ActiveCell.Formula = "=IF(B3<""\"",J" & i & "*R" & i & "+S" & i & ",""\"")"

--
Jim
"DKY" wrote in message
...
|
| I keep getting a compile syntax error on this line of my macro.
|
| ActiveCell.FORMULA = "=IF(B3<\"\",(J" & i & "*R" & i & ")+S" &
| i,\"\")
|
| what am I missing?
|
|
| --
| DKY
| ------------------------------------------------------------------------
| DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
| View this thread: http://www.excelforum.com/showthread...hreadid=393284
|