first row in array - ExcelBanter

Posted to microsoft.public.excel.programming

[email protected][_2_] RobcPettit@yahoo.co.uk[_2_] is offline

external usenet poster

Posts: 80

first row in array

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

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
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

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

Menu

About Us