Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

using set

ResolvedVersion 2003

carolina has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course

Using SET

In which situation do you use SET when you using variables?

RE: Using SET

Hi Carolina

When you declare variables some variable types are Objects.

When assigning values to Object variables you need to Set the data. For example:

Non Object

Dim Counter As Integer

Counter = 1

Object

Dim MyRange As Range

Set MyRange = Range("A5:M500")

Hope this helps

Carlos

Thu 27 Nov 2008: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.