Hi,
I need to copy and paste one sheet to another sheet exactly (values, formatting, grouping, zooming etc) but except formula.

How can I do it. Please provide me the code for this 'paste special' work.

Thanks in advance,
Suman