hi Macdave_19,

is the idea of this macro to change all the cells in the range to what is in b4 ?

steve