In this issue we will be looking at the importance of using 'named' ranges in EXCEL, including a quick and niffy way to access them using VBA.

Ever lost an important Word, Excel or Powerpoint document? Have a look at the downloadable demos available at www.officerecovery.com.

It is good programming practice to release resources allocated by using the 'set' statement. In VBA Help Newsletter Tutorial 4, we used the set statement to set 'fs' to the 'Application.FileSearch' object. When the variable 'fs' is finished with, the resources should be released by using the set statement again.

If such resources are not released in large projects, Windows can become both slow and unstable.

~ COOL WORD RESOURCE ~
Join the MicroSoft VBA in WORD Forum
[ SKILL LEVEL: Intermediate ]

One of the most powerful feature you can use in Excel is 'Named Ranges'. (To find out how to name ranges, ask the office assistant to help you with 'naming ranges'.)
One of the best reasons to use named ranges is to make your formulas and code easier to understand. "cost*taxrate" is a lot easier to understand than "C4*E14".
Once you are up and running with naming ranges, there are some pitfalls to be aware of, especially with the local and global scope for the names. tut6.htm looks at some of these issues and how it impacts upon using VBA.

~ COOL EXCEL RESOURCE ~
Look at 'Utilities' section at this site for an excellent explanation of how to create dynamic ranges!
[ SKILL LEVEL: Intermediate to Expert ]

Using VBA in ACCESS is not one of our strengths, although we are working on it. So, in this section, we will just point you towards some excellent resources.

~ COOL ACCESS RESOURCE ~
A chapter from the book 'Beginning Access 97 VBA Programming'.
[ SKILL LEVEL: Beginner ]