Issue with a selection into an array.

[starlev]

I am inputting from a spreadsheet a selection into an array.
If the selection has more then one argument everything seems to work fine.
However if the selection has only one item in the array it seems not to work correctly.
And we receive the following error type mismatch
how can we make it work if there is only one item in the array.

Please Login or Register  to view this content.

Thank you
Here is the code we are using:

[nigelbloomy]

It looks like you are assigning the upperbound to be the 2nd value in the array (UBound(Sku_Arr, 2)) but if the cell only has one value this isn't going to work.

[nilem]

maybe something like this

Please Login or Register  to view this content.

[starlev]

I’m not sure why I am doing so but seems to work.
Is there anyway I can check if the anyway has only one value in that case I will be able to make a if statement

[starlev]

I found the solution.
I needed to format the HTML in the range which is stored on the Excel sheet.
In my case since I did not know HTML I used Kompozer

Thank you for your help.