Firstly this post rlates to this threadhttp://www.excelforum.com/excel-gene...-one-cell.html but for clarity am starting a new thread as this will be a long post.
I am using a version of a script posted by Paul in that thread, the prupose of which was to split numbers across cells from the formatPlease Login or Register to view this content.
I need to introduce some error checking or similar as I now have found that when a field contains to many zero's and no dollars macro cannot complete. example formatsPlease Login or Register to view this content.
I would need the columns to then contain values so originating colums 0.00 and all other columns 0. maybe could use default values?Please Login or Register to view this content.
This is the script I am currently using.
Please Login or Register to view this content.
Bookmarks