first row in array

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RobcPettit@yahoo.co.uk - 20 Mar 2006 13:54 GMT

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 to this Message

Tom Ogilvy - 20 Mar 2006 17:01 GMT

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

or

myArray = Range("MyValues").Value

if isempty(myarray(1,1)) then

Signature

Regards,
Tom Ogilvy

> 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 to this Message