98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA
Excel VBA
Resolved · Low Priority · Version 2003
Wed 26 Nov 2008, 10:23Delegate Beyers said...
Beyers has attended:
Excel VBA Advanced course
Excel VBA
Is there any way of removing all formatting from cells(shading, borders, font style/colour etc) at once using VBA code?
Thu 27 Nov 2008, 10:09Trainer Stephen said...
RE: Excel VBA
Hi Beyers
Thank you for your question
Removing all the formatting involves manipulating multiple propeties of different objects (Font, Interior etc.). The quickest way would be to use a with structure.
For example
With RangeObject
.interior.colorindex = xlNone
.font.italic = false
.font.bold = false
End with
Regards
Stephen
Wed 3 Dec 2008: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding and unhiding rows using the keyboardCTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal |
