microsoft excel training class - With Loop

The UK's most regular instructor-led training courses.
Training information: microsoft excel training class · Excel training courses · Microsoft Office VBA training

Resolved · Low Priority · Version Standard

With Loop

John has attended:
Excel VBA course

by - delegate John [1 post] (2007 Aug 2 Thu, 09:46) Reply

What is the With Loop used for?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 27 Thu	Bloomsbury	4	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	2	book now	£235	£240
2003	2008 Dec 5 Fri	Bayswater	6	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
Full Schedule: See all 99 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: With Loop

by - trainer Carlos gold contributer [473 posts] (2007 Aug 6 Mon, 16:01) Reply

John

The With loop allows the user to refer to a particular object once while doing multiple actions to it.

eg

With AcitveCell.Font

.Bold = True
.Italic = True
.ColorIndex = 5

End With

Regards

Carlos

RE: With Loop

by - trainer Alan silver contributer [73 posts] (2007 Aug 10 Fri, 13:26) Reply

Not quite sure what you mean by With Loop, John - the With statement allows you to specify a single object for a series of operations, but is not used with the Loop command.

Can you be more specific - or give a piece of code which will show what you mean?

· Creating Charts with Excel
· How to check for and reduce errors in Microsoft Excel
· Features of Microsoft Excel that assist in Analysis of Financial Data
· How to Create Better Excel Spreadsheets: Part One
· How to Create Better Excel Spreadsheets: Part Two

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips