Posted to microsoft.public.excel.programming

ExcelMonkey[_52_] ExcelMonkey[_52_] is offline

external usenet poster

Posts: 1

Dynamic 2D Array

I know that a Dynamic 1D array for data in column B starting in B2 is:

Offset($B$2,0,0,CountA($B$2:$B$635586),1)

But what if I want to make this a a 2D array

--
Message posted from http://www.ExcelForum.com

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
array formula with a dynamic range.	Dave	Excel Worksheet Functions	2	June 26th 06 06:16 AM
How to declare a dynamic array	Peter Rooney	Excel Discussion (Misc queries)	4	April 13th 05 01:25 PM
Dynamic Array	dan	Excel Programming	4	January 27th 04 04:16 PM
see if dynamic array used	RobcPettit	Excel Programming	2	January 17th 04 12:44 AM
Q: Declaring a dynamic array	Srdjan Kovacevic[_4_]	Excel Programming	1	January 16th 04 07:24 PM

All times are GMT +1. The time now is 05:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us