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 courses london - How do I do loops?
vba courses london - How do I do loops?
Resolved · Low Priority · Version Standard
Thu 18 Jan 2007, 16:03Delegate Oliver said...
Oliver has attended:
Excel VBA Intro Intermediate course
How do I do loops?
Hey Garry,
How do I do loops in my speadsheet?
Thu 25 Jan 2007, 13:06Trainer Garry said...
RE: How do I do loops?
try this
Sub Example2()
For x = 1 To 5
if activecell > 10 then
Selection.font.colorindex=3
end if
activecell.offset(1,0).select
Next x
End Sub
try this
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 Display Alerts In ExcelWhen creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...". |
