Vba text to columns help

[srdr16]

I have a large formula that takes references from several different tabs in my worksheet. It creates a list of several hundred vlookups. The data that is added together is changeable.
I have successfully created the vlookups, I copy them as values and text to columns and the vlookups work fine.
I recorded the copy and paste and this also works fine, however the text to columns only works when I do it manually (or whilst recording it), if I try and run the process from the macros it just will not do anything (it goes thru every formula as if it's doing something but they still stay as text).
If I can crack this then I can fully automate my report, without this the end used will have to do all that manually.

 

[Joe4]

Welcome to the Board!

Please post your VBA code (as described here: How to Post Your VBA Code) so that we can see it.
Also note the "Text to Columns" only works on hard-coded data, and has no effect on values being returned by formulas.
So if the values are being generated by formulas, they need to be changed to hard-coded values before applying the "Text to Columns" on them.