Re: $$Excel-Macros$$ MACRO :PASTE SPECIAL

2011-04-13 Thread C.G.Kumar
of resources. hope this helps, Paul -- *From:* C.G.Kumar kumar.bemlmum...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Mon, April 11, 2011 5:47:04 AM *Subject:* $$Excel-Macros$$ MACRO :PASTE SPECIAL Dear all, Following code i am using to select

$$Excel-Macros$$ MACRO :PASTE SPECIAL

2011-04-11 Thread C.G.Kumar
Dear all, Following code i am using to select each worksheet (except ) to copy and paste special values in each worksheet in same workbook. But, i am not getting desired output . Could you one help to rectify the following code; Sub ConvertToValues() Dim ws As Worksheet For Each ws In

Re: $$Excel-Macros$$ MACRO :PASTE SPECIAL

2011-04-11 Thread Paul Schreiner
To: excel-macros@googlegroups.com Sent: Mon, April 11, 2011 5:47:04 AM Subject: $$Excel-Macros$$ MACRO :PASTE SPECIAL Dear all, Following code i am using to select each worksheet (except ) to copy and paste special values in each worksheet in same workbook. But, i am not getting desired output