Posted to microsoft.public.excel.programming

Daniel Uribe Daniel Uribe is offline

external usenet poster

Posts: 4

Autofill a dynamic range with a formula.

I have created a dynamic named range using the offset function, but now I want to fill that range with a formula, so that if the dynamic named range consist of 20 cells, the 20 cells will have the formula, and if I change the number of cells to 1000, the 1000 cells would have the formula. Is it possible to do this without using VBA?

Thank you.

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
Autofill Dynamic Range of Cells	KeriM	Excel Programming	2	August 30th 12 12:45 PM
Autofill Dynamic Range	Fester[_2_]	Excel Programming	1	December 8th 08 04:04 PM
making autofill range dynamic	sonang	Excel Programming	0	September 1st 04 10:59 PM
autofill with dynamic range	Bernie Deitrick[_2_]	Excel Programming	0	September 16th 03 02:55 PM
autofill with dynamic range again	a	Excel Programming	0	September 16th 03 12:26 PM

All times are GMT +1. The time now is 12:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us