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
|