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. You will used them every time when you need to copy something from external source (like Internet page) into a Word or Excel document, but you do not need all the colors and formatting. You just need the text. Normally, […]
Just before I forget, this article is about 2 great ways to load (include) HTML file from another HTML or from PHP. Among other things I will show how to load HTLM file from WordPress text widget. Problem – Why would you need to load an HTML text file in WordPress? Say, […]
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