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

first row in array
 

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