Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA

	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

Resolved · Low Priority · Version 2003

Reply Tue 7 Oct 2008, 16:28Delegate Emma said...

Emma has attended:
Excel VBA Intro Intermediate course

VBA

How do I assign a range to an object variable?

For upcoming training course dates see: Pricing & availability

Reply Wed 15 Oct 2008, 13:02Trainer Roy said...

RE: VBA

Emma,

Dim rng As Range
...
Set rng = Range("somename")

Always best to use named ranges.

/Roy MacLean

Excel articles

· Save time with Microsoft Excel
· Microsoft Excel can ensure you keep on top of your finances
· How To Use The Cell Styles Functionality In Excel 2010
· Training Budgets In A Bad Economy
· Copy And Paste In Excel

Please browse our web site to find out more about
excel 2003 training and other Microsoft training courses.

Excel tip:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

View all Excel hints and tips

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