+ Reply to Thread
Results 1 to 2 of 2

Error "#BUSY!"

  1. 09-01-2021, 08:42 AM #1
    VAer
    VAer is offline
    Forum Contributor VAer's Avatar
    Join Date
    09-10-2016
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    801

    Error "#BUSY!"

    Could someone please help me fix the code (attached)? What is wrong with it?

    It used to work fine, when I get historical data into Sheet "Dashboard" (right hand side of Dashboard), per my earlier thread https://www.excelforum.com/excel-pro...-function.html

    Now I am trying to clean up code and put historical data in a different sheet (adding sheet "Historical Data"), it turns out error "#BUSY!" There is only sheet change from previous code, but it does not get historical data now. I don't know where I mess up.

    How to fix it? Function Last works correctly.

    Thanks.

    Edit: Thanks. I was trying to share file on google drive, now it shows up correctly (no issue now). Not sure why, after closing the file and reopening the file, the historical data pops up.

    Please Login or Register  to view this content.
    Attached Images Attached Images
    Last edited by VAer; 09-01-2021 at 08:56 AM.
    Reply With QuoteRegister To Reply
  2. 09-01-2021, 08:46 AM #2
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,277

    Re: Error "#BUSY!"

    Insead of a picture it's better to post an example workbook so we have something to work with.

    Check the top yellow banner on how to.
    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.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make a pivot table for hourly head count of members in the gym to see "busy times".
    By blizzardw in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-24-2019, 10:07 AM
  2. "Countif" with "left" error, "Sumproduct" picking up not qualifying rows
    By drgkt in forum Excel General
    Replies: 35
    Last Post: 01-13-2016, 02:16 AM
  3. = EMBED("Forms.ComboBox.1","") error "Reference not valid."
    By CatharinaCatharina in forum Excel General
    Replies: 2
    Last Post: 12-11-2014, 09:58 AM
  4. [SOLVED] If Not ActiveSheet.Range("A1").Value Like "apple" Then MsgBox "Error"
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-18-2014, 02:16 PM
  5. [SOLVED] What are "ie.readyState" and "ie.Busy" for ?
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2013, 04:24 AM
  6. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  7. What is Error "Method "Paste" of object "_Worksheet" failed?
    By vat in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-17-2006, 04:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1