How to tell if array is empty....mine is not working

I have the following code.............it has a run time error when i try to determine the array is empty.........any ideas why this is ahappening?

I don't know much about arrays, but isn't "isarrayempty" a boolean?

Hi,

I've had this problem too. Check out the IsArrayEmpty function here:

http://www.cpearson.com/excel/vbaarrays.htm

Cheers,
Dom

thanks.

question: if i have the following code.......in this code the array is empty because i have not done anything with it yet.........i run your code on it and i get a type mismatch error. Am i using it wrong. i know i have not assigned anything to the array yet but can i only use the array after i assign and then take away things from it.

Please Login or Register  to view this content.

romperstomper............thanks.

Question:
For lngrow < 6 the sht_array never gets anything assigned to it. Since i assigned it as variant rather than array.........what would you recommend i do to test to see if any assignment had been made.

Please Login or Register  to view this content.

actually, i was just thinking ........if lngrow>6 then i can handle this case via the already present IF statements.

Thanks for all the inputs.

romperstomper,

thanks! that worked. i checked both cases and it worked. thanks.



snb,
i ran the code you sent...........i think its trying to tell me something useful but i am not sure what. cant seem to match up what is telling me with what is on sheet1.