vassili
06-14-2007, 03:32 AM
i'm having a hell of a time with this form i have to automate.
in the unit column there is a mix of numbers, words, and fractions (as text).
in the total units column i need to add a formula. for the time being, i'll just have it as 5 multiplied by whatever is in the unit column.
in the attachment you can see what i have to deal with. what do i have to do in vba to make the final output make sense? and how can i change the output #VALUE! to a custom message?
obviously when i multiply 5 by the words PCL or AR i'm gonna get #VALUE!, but i want it to say something else, like hello. how can this be achieved?
remember, everything is automated. i pull in the spreadsheet form through my macro program and i add the "total unit" column on after with a vba loop. what the attachment shows is the final output of my macro.
in the unit column there is a mix of numbers, words, and fractions (as text).
in the total units column i need to add a formula. for the time being, i'll just have it as 5 multiplied by whatever is in the unit column.
in the attachment you can see what i have to deal with. what do i have to do in vba to make the final output make sense? and how can i change the output #VALUE! to a custom message?
obviously when i multiply 5 by the words PCL or AR i'm gonna get #VALUE!, but i want it to say something else, like hello. how can this be achieved?
remember, everything is automated. i pull in the spreadsheet form through my macro program and i add the "total unit" column on after with a vba loop. what the attachment shows is the final output of my macro.