Home
Courses
- Application Training
  - PowerPoint training
  - Access training
  - Word training
  - Outlook training
  - ChatGPT training
  - Power Automate training
  - MS Project training
  - Visio training
  - View all 200+ courses
  Training Programs
  Professional & Management Development
  - Over 70 courses available for Individuals, Corporates, Resellers
  - View all courses
Promotions
- Our Promotions
  Promotions
  
  Last minute deals
  
  Excel Courses London
  We offer London's largest schedule of genuine dates (1102 as of 5:04pm Fri).
  
  Book with confidence up to 12 months ahead. Our MS Desktop & Management Skills courses are never cancelled.
  
  98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
  View Live Stats View Reviews
Schedule
- Our Schedule
  We offer London's largest schedule of genuine dates (1102 as of 5:04pm Fri).
  
  Book with confidence up to 12 months ahead. Our MS Desktop & Management Skills courses are never cancelled.
  
  98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
  View Live Stats View Reviews
Formats
- Course Formats
  All formats
  
  Public Scheduled Courses
  
  On-site Training
  
  Online Training (Virtual)
  
  Training Programs
  
  Closed Company Events
  
  Consultancy
  One to One training
  
  Training Needs Analysis
  
  Floorwalking
  
  Roll-out
  
  eLearning
  
  Executive Coaching
  When it comes to training, one size does not fit all. We have the ability to be flexible through our experience and commitment to quality.
  
  Whether it's training one person in your office, or assistance with migrating to a new system, we can help you.
  
  98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
  View Live Stats View Reviews
Our Clients
- Our Clients
  Client List
  
  Online Reviews
  
  Client Testimonials
  
  Client Feedback
  
  Case Studies
  "The friendliest service... Plus high quality training...could this be the best value training company in London!?"
  
  - Graham C., Learning & Development Manager, Home Office
  More Reviews
  
  98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
  View Live Stats View Reviews

VBA

Resolved · Low Priority · Version 2003

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

Emma has attended:
Excel VBA Intro Intermediate course

VBA

How do I assign a range to an object variable?

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

RE: VBA

Emma,

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

Always best to use named ranges.

/Roy MacLean

VBA

VBA

RE: VBA

Excel tip:

Jumping Between Sheets in a Book

Request A Callback

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

VBA

VBA

RE: VBA

Excel articles

Excel tip:

Jumping Between Sheets in a Book

Training Programs
Professional & Management Development