Hi,

I have the need to, due to memory when running an
automating macro have the information from a sheet in its
entirety copied (paste special, all equivelant) using a
button to do so. Can you tell me how I would code this
please. The sheet name is just sheet1.

Many Thanks.

Rob