Posted to microsoft.public.excel.programming

external usenet poster

Posts: 10

Array Problem

Can you please tell me if it is possible to return a value of say the second
cell (B1) from the following statement...

Dim data As Variant

data = Range("A1:E1").Value

I have tried numerous ways but can not get the value of each cell in the
range which I need to examine before actioning

Thanks

TAM

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 Problem	Scott	Excel Discussion (Misc queries)	4	May 9th 06 05:22 PM
Array problem	Bruce	Excel Programming	1	December 8th 04 07:55 AM
Array Problem??	Michael Vaughan	Excel Programming	6	November 12th 04 02:38 AM
Array Problem	Phil Hageman[_3_]	Excel Programming	0	November 19th 03 07:34 PM
Array Problem, Help Please.	Bubu	Excel Programming	9	November 18th 03 04:29 PM

All times are GMT +1. The time now is 04:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us