+ Reply to Thread
Results 1 to 5 of 5

Overflow 9 and empty value problems

  1. #1
    Registered User
    Join Date
    05-25-2019
    Location
    Denmark
    MS-Off Ver
    2019
    Posts
    13

    Overflow 9 and empty value problems

    Hi,

    Fairly new to this, and was hoping for someone to help/explain to me why im running into this problem.

    Please Login or Register  to view this content.
    My problem occur in section " 'Gæld og fremmedkapital "
    It won't find the value (Empty) even tho its there, and just some bonus info if its necessary, all the data is from an external website query

    hope you would be kind to help

    Best regards

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Overflow 9 and empty value problems

    Please Login or Register  to view this content.
    If this is the section you mean then try
    Please Login or Register  to view this content.
    I have no idea what the statement below means.
    It won't find the value (Empty)
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,905

    Re: Overflow 9 and empty value problems

    Depending which sheet is active when running the code forgetting the dots before Range could lead to unexpected results.
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  4. #4
    Registered User
    Join Date
    05-25-2019
    Location
    Denmark
    MS-Off Ver
    2019
    Posts
    13

    Re: Overflow 9 and empty value problems

    Hi Bakerman2
    It did the job, and thanks for the advice. Had no idea about the importance of dots before range. thanks

  5. #5
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,905

    Re: Overflow 9 and empty value problems

    You're welcome.

    In a With ... End With structure the dots refer to the Sheet in the structure, otherwise it refers to the ActiveSheet.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. [SOLVED] Problems finding the next empty cell and paste value
    By moosmahna in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2017, 08:47 AM
  2. [SOLVED] Problems With Macro to Copy Cells From One Sheet to Next Empty Row In Another Sheet
    By sliesneekr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-01-2014, 09:12 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. Problems with cell overflow
    By DJBittner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-06-2011, 11:41 AM
  6. Overflow on .Top = .Top + x
    By Doctorul in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-19-2009, 05:00 AM
  7. Overflow
    By Erik Beck Jensen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2005, 06:15 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