Posted to microsoft.public.excel.programming

external usenet poster

Posts: 59

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
writing formulas	David Cheeks	New Users to Excel	2	August 29th 08 12:00 AM
writing if formulas	mafarmer	Excel Worksheet Functions	1	December 5th 06 03:07 PM
Writing Formulas	Irv	Excel Worksheet Functions	2	December 28th 04 09:25 PM
Problem writing formulas - please, please help!	Oliver Kharraz	Excel Programming	1	December 1st 03 12:03 PM
VBA: Writing an array function (like MMult)	fxmolden	Excel Programming	4	November 13th 03 07:45 PM

All times are GMT +1. The time now is 12:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us