HI,As Length function doesn't consider the null values but Can anyone explain me why the below code has returned value 4 ? Thanks
Discussion posts and replies are publicly visible
Hello vidyaj0002 The type definition of each value in your array is the reason of this effect is what I understand. when you define the value as "Three" in your array, It is a List of Variant. where as if you are defining it as a number integer it would give you the correct answer.
I never knew why this always happened until now.
I thought it was a bug with the function. Looks like my entire childhood is ruined. Thank you Konduru Chaitanya !!
Hahaha. I realized it just a couple of weeks back.