One More thing that I forgot to mention Otto, Conan and Gary that is very
important is that I am also using autofilters with this worksheet. So that if
I select say anything in the filtered results and apply an edit to a offset
cell, the action is going to take place for each cell in between as well. The
only way that this does not happen is if i select each cell with a ctrl. Is
this the nature of the beast?