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 Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End Sub
Most of my job involves data manipulation/extraction. To do this, I
often write temporary functions which take existing raw data and turn
it into more easily-readable formats.
Since I share this data with sub-contractors and clients, I'm not
permitted to release what is in effect, my employer's intellectual
property. The macro allows me to highlight a range of cells, and with
one keystroke, replace the existing functions with the values.
On 18 Mar, 04:26, Ayush <jainayus...@gmail.com> wrote:
> Hello Everyone,
>
> I request you all to share any tips or tricks that you have about MS
> Excel in the group. It really helps.
>
> The tip can be anything like formula, most used calculation, excel
> trick, hidden truth or could be anything which you think can be done
> in an easier way.
>
> It can be any bug of excel also. Anything about excel that you
> know....anything
>
> Sharing just increases the knowledge.
>
> Keep Posting...
>
> Best regards,
> Ayush Jain
> Group Owner
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
