Hi,

The code has run this time, however it doesn't seems to be working, there is the full area copied over and it has copied formulas where as before it was just pasting values I think.