If you're always summing B6:E6, why not have the user select the destination cell before running the macro? Much simpler than messing around with Input boxes, validating the input then changing the selection to suit.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|