About Us

[email protected][_2_]

Hi, if name a1:a20 as 'myvalues' then in vba assign to an array
'myarray', how can I check 'myarray' to see if it contains any values
using vba. Or even check 'myvalues'. Either would do.
Regards Robert

Tom Ogilvy

if isempty(range("MyValues")(1)) then

or

myArray = Range("MyValues").Value

if isempty(myarray(1,1)) then

--
Regards,
Tom Ogilvy

" wrote:

Hi, if name a1:a20 as 'myvalues' then in vba assign to an array
'myarray', how can I check 'myarray' to see if it contains any values
using vba. Or even check 'myvalues'. Either would do.
Regards Robert

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Complex conditional summing - array COUNT works, array SUM gives#VALUE	fatcatfan	Excel Worksheet Functions	4	November 18th 09 06:41 PM
Prevent cell/array references from changing when altering/moving thecell/array	nme	Excel Discussion (Misc queries)	1	September 19th 08 01:53 PM
meaning of : IF(Switch; Average(array A, array B); array A)	DXAT	Excel Worksheet Functions	1	October 24th 06 06:11 PM
Array problem: Key words-Variant Array, single-element, type mismatch error	davidm	Excel Programming	6	November 9th 05 05:54 AM
Array problem: Key words-Variant Array, single-element, type mismatch error	davidm	Excel Programming	1	November 8th 05 04:21 AM

Menu

About Us