run-time error

Hi since i updated my code the error 70 "Permission Denied" keeps me from activating my search form. Const SEARCH_BLANK As String = "[BLANK]" Sub FilterData() Dim ws As Worksheet Dim i As Long Dim lastRow As Long Dim matchCriteria As Boolean ' Change "Sheet1" to the...

Hello All, I have trouble running the following macro (See the attached image). Sub Translation() Dim fndList As Variant Dim rplcList As Variant Dim x As Long fndList = Array("Pound Sterling", "Outgoing amount ATM/Dispenser", "Banknote") rplcList = Array("Libra Esterlina", "Salida dotación...

Version: MS Excel 2019 All macros are in ThisWorkbook location. Macros are activated by buttons. Although the macros are available through VBA viewer, I cannot select and link the macro to the button in the new file (the list is empty; see images attached). What does the macro do: The macro...

Hello, Developing a code in Excel VBA for work (code at the end of this post) and I am running into the following error a few times in the code: Run-time error ‘438’: Object doesn’t support this property or method This code (full code posted below at end) is executed in one workbook, opens...

I have two separate user forms of which the only difference is the place in which they put the data. The Userform "TaskForm" works fine but when i copied across the code to Userform "AssessmentForm" and changed the relevant details it says "File Not Found" Followed by "Run-time error 361" The...

Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...

The code below is acting as expected... If user enters "Personal" in any cell in Column J, cells on the same row in Columns K & L auto-fill with "Personal" If user enters either "Misc." or "Other Meals" in Column K, cells on the same row in column L auto-fill with the same word HOWEVER, any...

Hello - I hoping someone can help me with this. I created a macro using the Macro Recorder to sort a column on my spreadsheet by a custom list. CUSTOM LIST: PROJECT CANCELLED STAGE 1 - PI STAGE 2 - RD STAGE 3 - W STAGE 4 - LV STAGE 5 - LD PROJECT COMPLETE VBA CODE...

Hi Everyone, I installed Excel 2013 on my PC. and made the excel workbook with VBA in it. It is now perfectly running. When I went for work and used my newly made excel workbook. it started having many problems in our office we use Excel Office 365. the Error I am having is...

I have been working on this VBA code but I keep getting the error '-2147024809(80070057)' The specified value is out of range. Not sure why. I'm trying to copy values from the excel sheet to a powerpoint presentation for an awards ceremony. Any help would be appreciated. I'm using excel and...

Hello, I am having trouble with the below code. For some reason it will give a run-time error sometimes, but it is completely random. Unfortunately I can't provide the URL since it is internal but I'm thinking this error is due to a timing issue. As you can see below was my attempt at fixing...

I'm having some VBA problems. I've used the below code many times before on other workbook (just changing the specific parameters for each sheet)without any problem. However now I'm begging the "Run-time error '1004' Application-defined or object-defined error" error for the "East Mezz Input"...

I've been through this forum front and back and taking the suggestions from previous posts about this error has given me a lot of knowledge concerning this error, but the error persists nonetheless. Does someone see something I can be doing differently to stop this error from occurring? Sub...

MR. Excel Help Hi all, I am having trouble with a delete row macro for one of my tables in excel. When I run my "Call_Delete_Row" code in an existing table after I open my excel spreadsheet, the last row for two tables on two different sheets are deleted. However, AFTER I run...

Hi guys, so i keep getting an error saying "Object variable or with block variable not set" the code used to work perfectly before i added something what i added was Set rng = Range(Range("A1"), Range("A1").SpecialCells(xlLastCell)) Set tbl = ActiveSheet.ListObjects.Add(xlSrcRange, rng...

I have code in a program that clears all data from all forms on all sheets. As part of this program I execute the following code to delete all existing charts: Dim wsItem As Worksheet Dim chtObj As ChartObject For Each wsItem In ThisWorkbook.Worksheets For Each chtObj In...

Hi, I try to run an Access macro from an Excel macro. I've found some helping tips, but it still doesn't work. The relating part: Dim appAccess As Object Set appAccess = CreateObject("Access.Application") appAccess.opencurrentdatabase "G:\Risk Management\Common For Risk...

I wonder if anyone might be able to help me? I've come across an error in a workbook set up for the 2016 year (it was a direct copy of the 2015 original, clearing previous data and updating the date range). When I run the macro in the 2016 file, I am presented with the following error...

Hi fellow VBA practitioners, Today I have a challenging (maybe not?) exercise for those of you who know VBA. The case I'm about to describe is pretty simple, however completely kills all my weekend (second one to be precise). Case I managed to find & modify to suit my case the macro that would...

Hi, I'm new to creating user forms in excel so dealing with run-time errors is a little out of my wheel house. My user form has been working fine for over a year and then someone else edited my document and added a page to the multi-page user form. Since then this run-time error '2147417848...