Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time Error 6
I have a friend who is not too computer savvy to whom I sent a simple XLS
that contains a VBA macro I wrote to do some simple sorting of one of the sheets. When he runs it on his machine he gets what he claims is a "run time error 6" message. It's not clear to me sitting 5,000 miles away whether this is an Excel error or a VBA error message. What's frustrating to me is that I've typed every variation of the error message I can think of into both the Excel and VBA help systems and they don't come back with any explanation of what it means. Can anyone here point me to a source of explanations for messages of the "error 6" variety? FWIW, my system is Office 2003, while his is Office 2003 Professional. My understanding, perhaps misguided, is that those two systems have identical Excel packages though. The difference lies only in the inclusion of database software. Both systems are running under XP-Home. Thanks. Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time Error 6
Bill,
Error 6 is an "overflow" error. Lookup "trappable errors" in vba help. One of the most common reasons for this error occurring is using an Integer variable as a row designator. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Bill Martin" wrote in message I have a friend who is not too computer savvy to whom I sent a simple XLS that contains a VBA macro I wrote to do some simple sorting of one of the sheets. When he runs it on his machine he gets what he claims is a "run time error 6" message. It's not clear to me sitting 5,000 miles away whether this is an Excel error or a VBA error message. What's frustrating to me is that I've typed every variation of the error message I can think of into both the Excel and VBA help systems and they don't come back with any explanation of what it means. Can anyone here point me to a source of explanations for messages of the "error 6" variety? FWIW, my system is Office 2003, while his is Office 2003 Professional. My understanding, perhaps misguided, is that those two systems have identical Excel packages though. The difference lies only in the inclusion of database software. Both systems are running under XP-Home. Thanks. Bill |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time Error 6
runtime error 6 = overflow. Possibly an array index out of bounds.
-- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Bill Martin" wrote: |I have a friend who is not too computer savvy to whom I sent a simple XLS | that contains a VBA macro I wrote to do some simple sorting of one of the | sheets. When he runs it on his machine he gets what he claims is a "run | time error 6" message. It's not clear to me sitting 5,000 miles away | whether this is an Excel error or a VBA error message. | | What's frustrating to me is that I've typed every variation of the error | message I can think of into both the Excel and VBA help systems and they | don't come back with any explanation of what it means. Can anyone here | point me to a source of explanations for messages of the "error 6" variety? | | FWIW, my system is Office 2003, while his is Office 2003 Professional. My | understanding, perhaps misguided, is that those two systems have identical | Excel packages though. The difference lies only in the inclusion of | database software. Both systems are running under XP-Home. | | Thanks. | | Bill | |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time Error 6
Hmm... You may well be right. I'll try redimensioning it as LONG and send
the file off to see what happens. It is curious though why it should work on my machine and fail on his since they're both the same version of Excel running a small XLS file. Quite possibly his machine has less RAM installed though. Thanks... Bill --------------------------- "Jim Cone" wrote in message ... Bill, Error 6 is an "overflow" error. Lookup "trappable errors" in vba help. One of the most common reasons for this error occurring is using an Integer variable as a row designator. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Bill Martin" wrote in message I have a friend who is not too computer savvy to whom I sent a simple XLS that contains a VBA macro I wrote to do some simple sorting of one of the sheets. When he runs it on his machine he gets what he claims is a "run time error 6" message. It's not clear to me sitting 5,000 miles away whether this is an Excel error or a VBA error message. What's frustrating to me is that I've typed every variation of the error message I can think of into both the Excel and VBA help systems and they don't come back with any explanation of what it means. Can anyone here point me to a source of explanations for messages of the "error 6" variety? FWIW, my system is Office 2003, while his is Office 2003 Professional. My understanding, perhaps misguided, is that those two systems have identical Excel packages though. The difference lies only in the inclusion of database software. Both systems are running under XP-Home. Thanks. Bill |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time Error 6
No arrays are used, but I was using Integer for a row value rather than Long
as Jim suggested. The value never gets over 50 or so, but perhaps it's some sort of internal problem. Thanks Dave. Bill --------------------------------- "Dave Patrick" wrote in message ... runtime error 6 = overflow. Possibly an array index out of bounds. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Bill Martin" wrote: |I have a friend who is not too computer savvy to whom I sent a simple XLS | that contains a VBA macro I wrote to do some simple sorting of one of the | sheets. When he runs it on his machine he gets what he claims is a "run | time error 6" message. It's not clear to me sitting 5,000 miles away | whether this is an Excel error or a VBA error message. | | What's frustrating to me is that I've typed every variation of the error | message I can think of into both the Excel and VBA help systems and they | don't come back with any explanation of what it means. Can anyone here | point me to a source of explanations for messages of the "error 6" variety? | | FWIW, my system is Office 2003, while his is Office 2003 Professional. My | understanding, perhaps misguided, is that those two systems have identical | Excel packages though. The difference lies only in the inclusion of | database software. Both systems are running under XP-Home. | | Thanks. | | Bill | |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time Error 6
Maybe some of his data is in the bottom half of the worksheet?
-- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "Bill Martin" wrote in message Hmm... You may well be right. I'll try redimensioning it as LONG and send the file off to see what happens. It is curious though why it should work on my machine and fail on his since they're both the same version of Excel running a small XLS file. Quite possibly his machine has less RAM installed though. Thanks... Bill --------------------------- "Jim Cone" wrote in message Bill, Error 6 is an "overflow" error. Lookup "trappable errors" in vba help. One of the most common reasons for this error occurring is using an Integer variable as a row designator. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Bill Martin" wrote in message I have a friend who is not too computer savvy to whom I sent a simple XLS that contains a VBA macro I wrote to do some simple sorting of one of the sheets. When he runs it on his machine he gets what he claims is a "run time error 6" message. It's not clear to me sitting 5,000 miles away whether this is an Excel error or a VBA error message. What's frustrating to me is that I've typed every variation of the error message I can think of into both the Excel and VBA help systems and they don't come back with any explanation of what it means. Can anyone here point me to a source of explanations for messages of the "error 6" variety? FWIW, my system is Office 2003, while his is Office 2003 Professional. My understanding, perhaps misguided, is that those two systems have identical Excel packages though. The difference lies only in the inclusion of database software. Both systems are running under XP-Home. Thanks. Bill |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time Error 6
The max row number in excel is 65536 but perhaps your code added one to the
row number. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Bill Martin" wrote: | No arrays are used, but I was using Integer for a row value rather than Long | as Jim suggested. The value never gets over 50 or so, but perhaps it's some | sort of internal problem. | | Thanks Dave. | | Bill | --------------------------------- |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time Error 6
Oops, my bad. For unsigned int 32767 is max positive value.
-- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming |