Create a number array in vba

[ajm1991]

I have a range ("A1:A60") that contains numbers out 2 decimals and blanks.

Examples of the numbers in the range are 1.01, 1.02, 2.01, 2.02, 1.03, 1.04, 2.03

I'd like to do the following:

1. grab these numbers and put them in an array (maybe array is the wrong term)
2. add a "x.00" and "x.99" for every integer to the array.
(So in the above example, the array would now also include 1.00, 1.99, 2.00 and 2.99)
3. Sort the array Ascending
4. Paste the new array into cell B1.

Is this possible?

Thanks,
Ajm

[karedog]

Maybe :

Please Login or Register  to view this content.

[Kenneth Hobson]

Please Login or Register  to view this content.

[ajm1991]

@karedog, awesome! thanks a lot.

I changed this:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

otherwise the value of the last cell was being used.

one last thing - i forgot to mention that the integers can skip e.g. 1.01, 1.02, 14.01, 14.02, 2.01 and also have #N/A's in between integers. any way to sort them ascending? and skip the #N/As to speed it up?

@Kenneth, your code created a list.

[karedog]

You are welcome, thanks for the rep.points.

Please change the code to :

Please Login or Register  to view this content.

If this is still giving unexpected result, you need to upload your workbook (data and expected result).