VBA

The UK's most regular instructor-led training courses.
Training information: training courses in excel · Microsoft excel training · Microsoft Office VBA training

Resolved · Low Priority · Version 2003

VBA

Jenna has attended:
Excel VBA course

by - delegate Jenna [1 post] (2008 Jul 30 Wed, 16:25) Reply

What does run-time error 13 mean?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	4	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	1	book now	£235	£240
2003	2008 Dec 5 Fri	Bayswater	6	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: VBA

by - trainer Carlos gold contributer [473 posts] (2008 Aug 1 Fri, 10:57) Reply

Hi Jenna

Run-time error 13 is a Type mismatch error. This means that the variable isn't of the correct type.

A variable that requires an integer value can't accept a string value unless the whole string can be recognized as an integer (eg "125").

To overcome this problem you should always make assignments between compatible data types. For example:

An Integer can always be assigned to a Long, a Single can always be assigned to a Double, and any type (except a user-defined type) can be assigned to a Variant.

Hope this helps

Carlos

· Microsoft Excel Training Course
· Microsoft Excel Courses Teach Advanced Macro Techniques
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· How to Create Better Excel Spreadsheets: Part One

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

Excel tip:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

View all Excel hints and tips