error message

  1. F

    Excel File not opening

    Just curious if anyone has ran into this issue before. My work computer does not allow me to open my macro enabled workbook. My IT department is not sure why. However I am able to open it on my personal compute. Does anyone have any idea: Is there something wrong with excel on my computer? Is...
  2. N

    Code for Command Button - error message when other button not yet clicked

    Hello, i do have a file with two command buttons. Command Button 1 does check some fields and then save the file. Command button 2 does send the saved file attached to an email. I would now need a code that doesn't allow command button 2 to be pressed if the file wasn't saved (so if command...
  3. R

    Error message in userform if duplicate entry

    Hi, I have a data list and a userform to add additional row(s) with data. I would like an error message to pop up whenever duplicate data is entered in the according userform field on the basis of a specific column in a named table. A blank entry field is admitted, but no duplicate entries. I...
  4. V

    How to clear out cache

    I'm getting this problem "OUT OF MEMORY", when I run my vba. My vba basically takes various things from a online csv which grabs time, year, # of ad clicks, weather, and, it takes it from there and pastes it into my document every 5 seconds or so. So I have an up-to-date dashboard of...
  5. M

    Not Enough Memory Error Doing Basic Pasting Between Tabs

    I have a problem with a new laptop, whereby when I try to paste a filtered sheet into another sheet, which is something I do all the time and is a big part of my workflow. My system is an i7 9th Gen with 32 Gig of Ram and brand new and I have more than 20 gig of memory free when I encounter...
  6. C

    VBA to create an error message when any Power Pivot connection fails on refresh

    Hi, I have a workbook that is connected to my BI database through Power Pivot. I have some VBA which refreshes all the connections & creates the workbook. I would like some VBA that brings up an error message if one of the connections fails to refresh - similar to if I was to refresh through...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top