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 format![]()
Please 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 formats![]()
Please 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