View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ed ed is offline
external usenet poster
 
Posts: 59
Default Writing Array Formulas in VBA

Anyone know how to assign an array formula to a cell
using VBA? If possible, I'd like to use 'A1' format.
Follow on question: Complicating matters, the formula has
quotes in it - how do I force the quotes through without
VBA bugging out due to the extra quotes I'm putting
around the formula