Wasn't exactly the approach I had in mind, but I finally incorporated
that approach of multiplying by 1 into a macro and it works. Had to
assign a permanent range name the value of 1, rather than assign 1 to
a variable and then try and copy it and paste special with the
variable.

Thanks for the idea....

Bruce