How to group a list per "X" number then store to an array the grouped list.


#1

Hi Guys,

I’m quite new here and I’m not sure if I posted the right title for my query buy I need your expertise.

  • I have a list of numbers in array separated by “vbCrlf” character.
  • I need to group the numbers by 25 then store it to a new Array variable and this time it will look like its grouped. I would say for example, on the new Array variable (provided it is done), I will have an array containing 25 numbers separated by “vbCrlf” per element. Similar to paging navigation style.

I have something in mind but I’m sure it will take me a lots of codes and components. Is there a way to make it neat and short?

Thanks in advance!
Aldrin