Posted to microsoft.public.excel.programming

RenÃ©[_2_] RenÃ©[_2_] is offline

external usenet poster

Posts: 24

Making array from range

Hello,

I have a range on a worksheet. Cells A1 to A6 contain values. I want to make
an array from this with VBA so I can use this array in other VBA code.
But I don't know how. Can anyone help me?

gr
RenÃ©

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
making sure a cell in an array is not duplicated	Zombie0635	Excel Discussion (Misc queries)	2	August 28th 09 12:19 AM
Making all references in a range absolute	Kasper	Excel Discussion (Misc queries)	1	March 9th 09 02:09 PM
Making Array Formula, please assist!	Macinslaw	Excel Worksheet Functions	3	October 11th 05 09:46 PM
Making progress with array functions, another two questions	Don Taylor	Excel Programming	3	January 4th 05 08:30 PM
Making a relative range in VBA	aapjaap	Excel Programming	1	October 10th 03 02:17 AM

All times are GMT +1. The time now is 06:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us