run-time error '13'

Evening gurus, This VBA is to delete rows for any cells of Columns I containing "Failed" followed by cells on Column N containing "VALUE!". It works flawlessly for Column I criteria whoever 'Run-time error'13: Type Mismatch Error' occurs on Column N. All the columns has been pasted as value...

I have a basic data input sheet which users populate columns B through W with data. In hidden columns X through AS, I have a formula that returns "true" or "false" that checks the data values in each of the corresponding columns based on individual data requirements. In Column AT, I have a...

Hi Folks, I have developed some VBA code to move files from a source destination to a target destination. For example: <tbody> Item Code (A1) File path (B1) AQU10000753.pdf S:\APS_Logistics\Images\PetsAtHome\03) EXTERNAL CODE IMAGES\HIGH RES - CONTAIN PRODUCTION MARKS!\NOT UPLOADED\...

Hello everybody! I got some amazing help last time I posted, so I'll give it another go. I'm still very new to coding in excel and find myself stuck with a Run-time error yet again. This is the code I'm working with: Private Sub Worksheet_Change(ByVal Target As Range) Dim n As Long If Not...

I am trying to do a dynamic "Hide Rows" function where if a certain cell in a row has any value a number "1" will populate the A cell of that row, an example would be if cell B11 has value A11 will be equal to "1"... What I had the macro doing was hiding all rows where A = "" The code had been...

Hi all, Complete newbie here, but coming across an issue with my VBA code and I'm not sure how to fix! The only VBA code on this spreadsheet is below, which I am using for popping up message boxes when certain cell values are changed or selected from the data validation drop down. It works...

Hi All I'm back begging for help again. Keep getting run-time error message when i get to the "convert values to a vertical array" part below in Red. Can anybody see where i'm going wrong please. it should be making a list of request numbers for a combobox in a userform so i can update...

Hi guys, I have been reading this forum but never joined until today. I have an issue. We have an Excel spreadsheet that has multiple macros running in it and was created by another controls engineer at out plant. He has since moved on and we are now trying to run his Data Query that is in the...

Hello, I am getting a Run-time error 13: Type mismatch when I enter anything in column 8 that does not = "YES". The red below is where the error is coming from. Can anyone help? Thanks! Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 8 Then If Target.Value...

Hi, Im trying to Call a macro in vba automatically when the value of cell A3 is changed. The macro runs, but when its finished I get the Run-time error 13 - Mismatch Now I read on different places that this means for instance a string and a number are mixed up in a formula. I just don't see how...

Hi everyone, I'm trying to operate a macro that loops through all connections strings in a workbook and defines them to their base form as defined in "DBPath" range below. Is there any way to do this? I get a run time error '13' type mismatch with what I'm currently trying below. Any help would...