+ Reply to Thread
Results 1 to 2 of 2

runtime error 6 overflow for code can't solve.

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    runtime error 6 overflow for code can't solve.

    Hi All,

    I'm very new to programming but I have a data set that I'm looking to process from a code that I did not write. I continually get a 'Run-time error 6...overflow' message box pop up. When I open the debugger it highlights

    nend = ActiveCell.Row. (I've bolded the line in question within the code).

    The active row seems to be 65536 but my data set only goes upto 6000.

    Here is a copy of the entire code


    Please Login or Register  to view this content.
    Any help would be greatly appreciated. For anyone with some ideas, thanks a lot in advance

    Jeev
    Last edited by fequalsma; 04-29-2013 at 10:58 AM. Reason: Use code tags in future.

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: runtime error 6 overflow for code can't solve.

    Try changing
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1