Re: $$Excel-Macros$$ Paste Special VS Paste Special

Thank you very much Sam. it works. > > From: Sam Mathai Chacko >To: excel-macros@googlegroups.com >Sent: Monday, 21 November 2011 9:59 PM >Subject: Re: $$Excel-Macros$$ Paste Special VS Paste Special > > >To copy paste a format from

Re: $$Excel-Macros$$ Paste Special VS Paste Special

if i want to copy paste only format from 1 workbook to > another then how can i achieve that. > > -- > *From:* Venkat CV > *To:* excel-macros@googlegroups.com > *Sent:* Monday, 21 November 2011 7:56 AM > *Subject:* Re: $$Excel-Macros$$ Paste Special

Re: $$Excel-Macros$$ Paste Special VS Paste Special

Hi, Thank you all. in this case if i want to copy paste only format from 1 workbook to another then how can i achieve that. > > From: Venkat CV >To: excel-macros@googlegroups.com >Sent: Monday, 21 November 2011 7:56 AM >Subject: Re: $$Excel

Re: $$Excel-Macros$$ Paste Special VS Paste Special

Hi Hanumant, First one you have copied data from Some other Application(New Window workbook,World..Etc) window and 2nd one Copied from Same window same sheet's That's what it's Showing different Options... *Best Regards,* *Venkat * *Chennai* *My Linked in profile

Re: $$Excel-Macros$$ Paste Special VS Paste Special

The classic paste special window pops-up when a range is copied within the current application, and the other paste special window pops-up when something is copied in to the clipboard from outside the application, or a non-range is copied from within application. Regards, Sam On Thu, Nov 17, 201