Doc,

Recorded macros are far too literal... they almost always need to be edited, especially when the
cell values are being edited.

HTH,
Bernie
MS Excel MVP


Thanks, That worked. Is there a reason the recorded macro didn't work and was
so different?