hi all,

StephenR & myself have been helping a user modify a macro which will
coordinate price changes on inventory based on user inputs from Input boxes
at http://Excelforum.com. If the Input box is cancelled a mismatch error
occurs due (I think) to the previous variable declaration as long.
My reading suggests that it is best to declare variables explicitly rather
than use variants so to apply this I have used "on error resume" to make the
code work.

Is this the best approach?

For more background please refer to the below thread & can you please reply
to the below thread for the original op?
http://excelforum.com/showthread.php?t=621111

Also, feel free to make any suggestions for improving the current code...

I apologise if this is not the best way for asking for help. If it's not,
can someone please let me know how I should ask?

Thanks
Rob

__________________
Rob Brockett
NZ
Always learning & the best way to learn is to experience...