Re: $$Excel-Macros$$ Paste Special VS Paste Special
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
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.inwrote: 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 http://in.linkedin.com/pub/venkatesan-c/21/492/a71 * On Thu, Nov 17, 2011 at 9:49 PM, hanumant shinde arsfan2...@yahoo.co.inwrote: 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
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 http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Thu, Nov 17, 2011 at 9:49 PM, hanumant shinde arsfan2...@yahoo.co.inwrote: 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
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 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
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, 2011 at 9:49 PM, hanumant shinde arsfan2...@yahoo.co.inwrote: 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 -- 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