error message

  1. N

    Excel Live Data Refresh - Stop all popups and errors

    Hi All, I am pretty amateur at Excel VBA, so please bare with. I have an excel workbook, this contains lots of worksheets with live data in SQL. The issue I have, is each worksheet is set to data refresh every 5 minutes, independently. Sometimes when it refreshes, it will give an error about...
  2. 3

    ByRef argument type mismatch

    Hi, I have the following code. However this line of code throw an error message. col_Arr = return_column(rng_column_loop, previous_Month) Error message: Compile ErrorByRef argument type mismatch The function requires range as argument. I passed in range. So why was the mismatch? thank you...
  3. P

    Error vba for checking if required fields are not empty.

    Hi, I'm looking for vba code to check if column A has a value then column C must also have a value. I would like it to prompt me before saving. Basically its a supplier list and if a supplier name is listed in column A then the commodity they provide must be filled in column C to comply with...
  4. P

    The requested operation cannot be performed on a file with a user-mapped section open...

    I am trying to load access data into excel but I am getting an error message that says: The requested operation cannot be performed on a file with a user-mapped section open... Does anyone know what I need to do in order to be able to load the data to the data model. Here is the message: The...
  5. F

    #value!

    #VALUE! Error I have an Excel spreadsheet in which a random number and a blank is generated for a Numerator for a Fraction in Column F and a Denominator is generated in Column G using a formula based on the number which is generated in Column F. When I attempt to generate the resulting value...
  6. M

    Make For Loop Show Error Message

    Hi everyone, I can't figure out how to make my simple for loop code show an error message when it no longer finds any cell(s) that meet the criteria. The criteria is that the first cell must match "K1110" while 4 cells to it's right must be blank. Please note that this code works fine. But...
  7. K

    Invalid Reference Error on INDEX MATCH to image

    Greetings all! I am a new member to MrExcel Discussion Boards, but have relied on your wisdom for years. Unfortunately, I came across an issue that I cannot find a solution to, and I have tried searching everywhere for an explanation. I will try explaining as best as I can, please let me know...
  8. K

    Invalid Reference Error on INDEX MATCH to image

    Greetings all! I am a new member to MrExcel Discussion Boards, but have relied on your wisdom for years. Unfortunately, I came across an issue that I cannot find a solution to, and I have tried searching everywhere for an explanation. I will try explaining as best as I can, please let me know...
  9. D

    Errror message

    Hello everyone i need a small piece of code. for example in column c i have alpha numeric characters like "PLN5555" so i need a code that prompts me error message when i type alpha numeric characters less than or greater than 7characters. any one can help me out in this. thanks in advace
  10. S

    Messy VBA code. IF AND statement not working and Userforms

    Being relatively new to userforms and some VBA code I have attempted to draft a macro for a command button. The code in essence is supposed to do the following: 1) Once you select a scheme name (one) and list of staff (one or more)y 2) You press the command button and this inserts new rows in a...
  11. S

    Problems with file from Google Sheets

    I downloaded a Google Sheet as an Excel file, and I am trying to copy/ cut a number of rows from a Spreadsheet into a new worksheet. When I try to paste or insert the cut rows I receive the following error message: "Excel ran out of resources while attempting to calculate one or more...
  12. D

    Error "Couldn't get data from the Data Model"

    I keep getting the following error when I try to refresh a pivot table (not Power Pivot). "We couldn't get data from the Data Model. Object reference not set to an instance of an object". I tried re-selecting the data source, but would get the same error message. I checked to see that I have...
  13. G

    Excel ERROR Message

    Hey everyone, so I was making a pivot table in Excel and I wanted to delete it. I highlighted the pivot table and hit delete on my keyboard. The error message is "Cannot enter a null value as an item or field name in a PivotTable report." I close the error message and any time now I click on...
  14. M

    combine ranges into one peice of code create error message for rounding code

    Hi All, I have the following piece of code that will round value (positive and negative values) to the nearest 0.5: For i = 33 To 35 With Sheets(1).Cells(i, 14) If .Value <> "" Then .Value = Application.MRound(.Value, Sgn(.Value) * 0.5) End If End With Next For i = 12 To 21 With...
  15. S

    Getting a 'formula too long' error when trying to save.

    "One or more formulas in this workbook are longer than the allowed limit of 8192 characters. To avoid this limitation save the workbook in the Excel binary Workbook format" So I have a workbook with about 40 tabs. I went in and on one tab inserted a copied row (from the same tab). There are...
  16. R

    Error message when i open the 2013 excel file with macro

    Hi there, I havean error message "excel found unreadable content in "name of the wb 2013 excel file" do you want to recover the contents of this workbook? if you trust the source of this workbook, click yes" If i click yes "name of the wb 2013 excel file" [REPAIRED] <<----- file name.. and try...
  17. K

    VBA error message "Range of Object_ Worksheet failed"

    Hi, having issues with my code and getting the error message "<Method 'Range' of object '_Worksheet' failed>" My code below, I just want to hide rows within the worksheet. this code worked fine before but when I made a change to the row numbers, I received this error message. Can anyone help...
  18. B

    Nestling: The specified formula cannot be entered because it uses more than 64 levels of nestling

    Hi there, I'm new to the community. Please help me to follow the right procedures. I have a problem with nestling and I need your help. Here's the formula, it's a simple ifand formula. The formula works like a beauty until the last city (Yangon). Then the error message pops up. The...
  19. U

    Help! filename.xlsx is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen ....xlsx

    I have a spreadsheet which has a few other spreadsheets linked to it (some are linked as array) and every time I open it, it comes up with this message for every linked spreadsheet. I have to click on yes/no for numerous times before I can start working on it. Really annoying. Any help will be...
  20. A

    .xls file saved by VBA gives file format does not match file extension error message when opening

    Hi all, I'm using the below code to prompt users to save the finished output from a macrobook and while the file can be opened safely, it throws up an error message; "the file you are trying to open, "...filename here...<FILENAME>" is in a different format than specified by the file extension...

Some videos you may like

This Week's Hot Topics

Top