Thank you very much Sam. it works.
>________________________________ > From: Sam Mathai Chacko <samde...@gmail.com> >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 one workbook to another workbook, you just need to >ensure both the workbooks are open in the same instance of the application. > >Regards, >Sam Mathai Chacko > > >On Mon, Nov 21, 2011 at 10:46 AM, hanumant shinde <arsfan2...@yahoo.co.in> >wrote: > >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 <venkat1....@gmail.com> >>>To: excel-macros@googlegroups.com >>>Sent: Monday, 21 November 2011 7:56 AM >>>Subject: 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 >>> >>>On Thu, Nov 17, 2011 at 9:49 PM, hanumant shinde <arsfan2...@yahoo.co.in> >>>wrote: >>> >>>Hi Friends, >>>> >>>>i have attached screenshot which has 2 windows for paste special >>>>functionality. >>>>i wanted to paste only formula but i got 1st window (Left from reader) >>>>hence could not do so. can somebody please tell me in what circumstances >>>>which window appears. >>>>i.e. which window will open when -- >>>>FORUM RULES (934+ members already BANNED for violation) >>>> >>>>1) Use concise, accurate thread titles. Poor thread titles, like Please >>>>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>>will not get quick attention or may not be answered. >>>> >>>>2) Don't post a question in the thread of another member. >>>> >>>>3) Don't post questions regarding breaking or bypassing any security >>>>measure. >>>> >>>>4) Acknowledge the responses you receive, good or bad. >>>> >>>>5) Cross-promotion of, or links to, forums competitive to this forum in >>>>signatures are prohibited. >>>> >>>>NOTE : Don't ever post personal or confidential data in a workbook. Forum >>>>owners and members are not responsible for any loss. >>>> >>>>------------------------------------------------------------------------------------------------------ >>>>To post to this group, send email to excel-macros@googlegroups.com >>>> >>> >>> >>> >>>-- >>> >>> >>> >>> >>> >>> >>> >>>-- >>>FORUM RULES (934+ members already BANNED for violation) >>> >>>1) Use concise, accurate thread titles. Poor thread titles, like Please >>>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >>>not get quick attention or may not be answered. >>> >>>2) Don't post a question in the thread of another member. >>> >>>3) Don't post questions regarding breaking or bypassing any security measure. >>> >>>4) Acknowledge the responses you receive, good or bad. >>> >>>5) Cross-promotion of, or links to, forums competitive to this forum in >>>signatures are prohibited. >>> >>>NOTE : Don't ever post personal or confidential data in a workbook. Forum >>>owners and members are not responsible for any loss. >>> >>>------------------------------------------------------------------------------------------------------ >>>To post to this group, send email to excel-macros@googlegroups.com >>> >>> >>> >> -- >>FORUM RULES (934+ members already BANNED for violation) >> >>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not >>get quick attention or may not be answered. >> >>2) Don't post a question in the thread of another member. >> >>3) Don't post questions regarding breaking or bypassing any security measure. >> >>4) Acknowledge the responses you receive, good or bad. >> >>5) Cross-promotion of, or links to, forums competitive to this forum in >>signatures are prohibited. >> >>NOTE : Don't ever post personal or confidential data in a workbook. Forum >>owners and members are not responsible for any loss. >> >>------------------------------------------------------------------------------------------------------ >>To post to this group, send email to excel-macros@googlegroups.com >> > > >-- >Sam Mathai Chacko >-- >FORUM RULES (934+ members already BANNED for violation) > >1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get >quick attention or may not be answered. > >2) Don't post a question in the thread of another member. > >3) Don't post questions regarding breaking or bypassing any security measure. > >4) Acknowledge the responses you receive, good or bad. > >5) Cross-promotion of, or links to, forums competitive to this forum in >signatures are prohibited. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum >owners and members are not responsible for any loss. > >------------------------------------------------------------------------------------------------------ >To post to this group, send email to excel-macros@googlegroups.com > > > -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com