Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » When do I use the with function
|
|
|
Bookmark this page|
The UK's most regular 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. |
When do I use the with function
Resolved · Low Priority · Version 2007
Reply
When do I use the with function
when do I use the with functionFor upcoming training course dates see: Pricing & availability
RE: when do I use the with function
Hi PeterThank you for your question.
The With construct is used to make code more readable and therefore easier to maintain.
Example that groups commands refereing to the Font of the selection
With Selection.Font
.Name = "Verdana"
.FontStyle = "Italic"
.Size = 14
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
End With
Regards
Laura GB
Tue 27 Jan 2009: Automatically marked as resolved.
|
 |
|
» Forum post: Libary resources |
Why do I need to use the library to edit images? Why can't I just edit directly from the images folder.
