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

2011-04-13 Thread C.G.Kumar
> I think its done. please check and let us know if this is what you wanted > to do. > > > *From:* C.G.Kumar > *To:* excel-macros@googlegroups.com > *Cc:* schreiner_p...@att.net > *Sent:* Mon, 11 April, 2011 8:52:17 PM > *Subject:* Re: $$Excel-Macros$$ MACRO :PASTE SPEC

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

2011-04-11 Thread Paul Schreiner
___ From: C.G.Kumar 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 g

$$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 Worksheet