$$Excel-Macros$$ Re: Share Tips and Tricks

2010-03-23 Thread Ayush
Hi Harpreet, Its a good suggestion to have new subject title with a keyword TIP. Dear Group, Please share the tips and tricks in a new email message with the TIP keyword. It really helps. Best regards, Ayush Jain On Mar 24, 8:35 am, Harpreet Singh Gujral wrote: > Hi Ayush, > > Looking at Sudhir

$$Excel-Macros$$ Re: Share Tips and Tricks

2010-03-23 Thread Harpreet Singh Gujral
Hi Ayush, Looking at Sudhir's idea, i think it would be great to consolidate all the tips and tricks. But, i also buy in your point, that it would be difficult to keep the file updated. I have a suggestion, Would it be possible for you or the members of the group to follow a pattern for forwardin

$$Excel-Macros$$ Re: Share Tips and Tricks

2010-03-18 Thread ~slacker~
with Excel 2007 the Help options seem to be much better. Along with this a pretty extensive list of shortcut keys http://office.microsoft.com/client/helppreview.aspx?AssetID=HP100738481033&QueryID=2M8Hx7LZd&respos=5&rt=2&ns=EXCEL&lcid=1033&pid=CH100947761033 some of my favorites: CTRL+SHIFT+END e

$$Excel-Macros$$ Re: Share Tips and Tricks

2010-03-18 Thread Ayush
Thanks group for your overwhelmed response on this topic. @Shyam : Thanks for sharing tips and bugs. you are excellent member of group. I am proud that you are part of this group. Keep Posting. @Sudhir : Thanks for idea but it appears tedious to edit the file and upload in the group. There will b

$$Excel-Macros$$ Re: Share Tips and Tricks

2010-03-18 Thread draco664
Personally, whenever I start a new job, or install a new version of Excel, the first thing I do is record the following macro. Sub CopyPasteSpecialValues() ' ' CopyPasteSpecialValues Macro ' Macro recorded 27/11/2008 ' Keyboard Shortcut: Ctrl+Shift+V ' Selection.Copy Selection.PasteSpecial