Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - How do I do loops?

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

vba courses london - How do I do loops?

Resolved · Low Priority · Version Standard

Reply 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?

For upcoming training course dates see: Pricing & availability

Reply 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

VBA articles

· If It's Not Broken Why Should You Fix It? Find Out With VBA
· Microsoft Excel, Tailor-Made For Your Business Thanks To VBA
· Tips On Getting VBA Bugs To Bug-off
· OOPS Visual Basic Did It Again
· Starting Out With Excel 2007 VBA Using The Macro Recorder

Vba tip:

Use VbNullString instead of

When needing to default a String variable back to it's default of "" use vbNullString as in the following example:

Sub ClearText()

Dim strEmpName As String

strEmpName = "John Smith"
MsgBox strEmpName

strEmpName = vbNullString
MsgBox strEmpName

End Sub

View all VBA hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy