best training excel intermediate

best training excel intermediate - Excel VBA

Resolved · Low Priority · Version Standard

Excel VBA

Chi Wah has attended:
Excel VBA course
Excel VBA course

by - delegate Chi Wah [1 post] (2007 Oct 11 Thu, 16:42) Reply

why do you use Set in some variable declarations?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
Full Schedule: See all 109 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel VBA

by - trainer Carlos gold contributer [479 posts] (2007 Oct 17 Wed, 12:44) Reply

Chi Wah

Thanks for the question.

The word Set is used in VBA to assign an Object to an Object type variable. eg

Dim MyRange as Range

Set MyRange = Sheets("Sheet1").Range("A1:D20")

Carlos

· Advanced Excel and PivotTable Reports
· Microsoft Excel Training Course
· How to check for and reduce errors in Microsoft Excel
· Excel and Inventory Management
· Identifying Suitable Candidates For VBA For Excel Training

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Rate this page: