From: tompl on
Did you add the .value or .formula? I found that is necessary to make it
work, but you might be better off using the copy command as that copies
everything about the cell.

Tom