error message

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...

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...

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...

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...

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...

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...

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...

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...

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...

#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...

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...

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...

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...

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

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...

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...

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...

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...

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...

"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...