Dave Peterson wrote...
But he used:
With activesheet.usedrange
so he was ok with .offset(introws,0).resize(1,1)
....

You're right. Sorry Duke.

However, it's still better to operate only on numeric constants. While
the PasteSpecial operation wouldn't change cells containing text,
boolean or error constants, it'd screw up cells containing formulas and
convert blank cells to cells containing the numeric constant zero.