Application.Transpose

[AlexanderBB]

This was recommended as a way to build an array from Values in a Worksheet row, In this example Col Y to AF in row chRow

Dim Ary as variant
 Ary = Application.Transpose(Application.Transpose _
             (Worksheets(.Name).Range("Y" & chRow & ":AF" & chRow).Value))

If works great but I've struck a problem. If only Col Y contains a value Ary is a string.
My code fails as it expects an array.
What is a good way to resolve this ? I can test isArray(ary) and perhaps force the string into an array but it doesn't seem right.

 

[MARK858]

You entered the date as a number then changed Cell format to dd mmm yyyy ?

I entered it in a recognized date syntax for my region (i.e. I entered it as 14/2/25) with the cell in it's default General number format, then changed the cells custom number format

Something about the cells format needing to be set when the cell was empty.

The only cell format to be avoided (unless you have a specific need) before entering your data is Text