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 VBA Training and help » vba training london - VBA
vba training london - VBA
Resolved · Low Priority · Version Standard
Thu 21 Jun 2007, 16:50Delegate Sharon said...
Sharon has attended:
Excel VBA Intro Intermediate course
VBA
How do I use the "withloop"?
Mon 2 Jul 2007, 10:51Trainer Carlos said...
RE: VBA
Hi Sharon
The 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
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 tip:Stop Screen Flickering When Running CodeRunning VBA code may cause the screen to flicker as the monitor is the slowest part of the program and cannot keep up with the very fast changes taking place. |
