View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Keep getting runtime error 1004

And I bet you read VBA's help that said arrayformulas had to be passed in R1C1
reference style.

If your formula is easier to do in A1 reference style, try that in your code.

ps. Sometimes if you build the formula in the worksheet, then post that to the
newsgroup, it'll be easier for others to figure out what you're looking for.



wrote:

Well, I'm actually trying to give an R1C1 value to sRngLot and sRngCol
that can be used in the FormulaArray. Removing the single quotes does
not help.


--

Dave Peterson