Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft VBA Training and help » vba training london - "with" statement
|
|
|
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. |
vba training london - "with" statement
Resolved · Low Priority · Version Standard
Reply
"with" statement
what does the "with" statement do?For upcoming training course dates see: Pricing & availability
RE: "with" statement
Hi PetrusThe With Statement is very useful if you are using several statements in a section of code that apply to the same object.
It stops you having to fully qualify the object each time.
For example:
Worksheets("Accounts").Range("A1") .Font.Bold = True
Worksheets("Accounts").Range("A1") .Value = 47.5
Can be coded as below:
With Worksheets("Accounts").Range("A1")
.Font.Bold = True
.Value = 47.5
End With
Regards
Carlos
|
 |
Formatting Shapes In Visio With The Keyboard And Mouse When formatting shapes in Visio, the F4 key is a great aid. When formatting on a greater scale, however, the mouse-operated Format Painter is the boy for the job. » Article: Visio training in london |
» Forum post: Tables |
» Tip: Pivot table grouping |
Where do i go to make complex table structures? and is it possible to import tables from microsfoft to excel and vice versa?
If you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other. 
