This Excel macro allows changing cells in selection based on the first cell in a selection:
If Selection.Cells(1, 1).WrapText = True Then
Selection.WrapText = False
Else
Selection.WrapText = True
End If
This is useful in Excel 2003 and bellow. Starting from Excel 2007, there is a button to perform this task on a Task Ribbon.
These two macros will save you a lot of time. They used, when you need to copy something from Internet page into a Word or Excel document, but you do not need all the colors and formatting. You just need the text. Usually you would do this with Paste Special, but […]
This article is about time saving, when it comes to enable your macros in Excel every time you open the file. You do not want to allow all macro to run. But if you don’t, you have to constantly enable your macros over and over again, when you open your […]
© 2017 DomainWebCenter.com. All Rights Reserved. | Disclaimer | Contact the Editor
Be the first to comment