+ Reply to Thread
Results 1 to 6 of 6

overflow issue

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    norfolk
    MS-Off Ver
    Excel 2007
    Posts
    28

    overflow issue

    Hello i seem to have a problem with this code i created,
    If the sheet already exists it goes through the alternative path however when it gets to

    Please Login or Register  to view this content.
    i get a pop up box saying overflow, i cant seem to work out why

    Please Login or Register  to view this content.
    Last edited by jetset1; 06-21-2014 at 03:21 PM. Reason: didnt indent apologies

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,888

    Re: overflow issue

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-10-2013
    Location
    norfolk
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: overflow issue

    apologies can you confirm my amendment to the code is okay?

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,437

    Re: overflow issue

    Perhaps, you want to
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    10-10-2013
    Location
    norfolk
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: overflow issue

    hello jindon, i tried that still get the overflow issue

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,437

    Re: overflow issue

    If you are getting overflow, change integer to long type variable.
    e.g
    Please Login or Register  to view this content.
    By the way, you need to declare each variable type for every variable.
    e.g
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    10-10-2013
    Location
    norfolk
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: overflow issue

    Hello Jindon, i Just worked it out. Here i state the name of the sheet will be

    Please Login or Register  to view this content.

    Further down where i start using c

    I was stating c as c.value

    This should have been c.text
    Last edited by jetset1; 06-22-2014 at 09:55 AM. Reason: better written

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Will it do any harm to the computer if I ignore the Overflow issue in Excel 2002
    By kwfine in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-03-2014, 07:53 AM
  2. Issue in macro getting overflow error
    By expert40 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2013, 11:43 AM
  3. Help with overflow
    By jscott932 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2013, 08:57 AM
  4. Replies: 3
    Last Post: 12-29-2011, 08:07 AM
  5. Overflow on .Top = .Top + x
    By Doctorul in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-19-2009, 05:00 AM

Tags for this Thread

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