Thread: Excel Formula - Error 1004 - Bug? Mistake?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Markus Wilthaner Markus Wilthaner is offline
external usenet poster
  
Posts: 2
Default Excel Formula - Error 1004 - Bug? Mistake?
Hello,

I have a worksheet and the following line of code:
Me.Range("G11").Formula = "=SUMIF(A1;1;A3:A6)"

Excel says: 1004 Application error

What am I doing wrong? If I enter the exact same string as a formula,
everything works fine. Help! :)


Markus
Reply With QuoteReply With Quote