on error

This is a Macro that has taken me weeks of research to write, mainly because I have had no experience with Macro before and finding the information on how to write the different codes took alot of research so I am sharing this Macro on here so that anyone struggling with any part of their macro...

Hey everyone, I am having some trouble with this one. I am finishing up a very large VBA. There are three instances where I select a column, search for a particular word (i.e.- "MOVE") and select that cell. That works perfect. The problem is when the word is not found. Once in a while, that...

I want to look and see if a file exists (based on a date entered into an input box). If the file exists, I want to delete the file. If the file does not exist, I want the macro to move onto the next line without an error message. The code below works when the file exists but gets stuck on the...

Is there a way you can make errors show as the code name and ln, Col numbers instead of error debug/End I have a workbook that anyone uses and id rather the user contact me with a error code so i can see where the error occured

Hello and thank you for looking at my question. I have the following vlookup VBA code On Error Resume Next x = WorksheetFunction.VLookup(tpmWS.Cells(i, j), dataWS.Range("A1:D" & LastRow), 4, False) If Err.Number = 0 Then tpmWS.Cells(i, j + 14) = x The issue I am having is that...

I am trying to create code to control an inventory tracking sheet. I have 4 sheets in my workbook: Master, Add, Remove, & Not Found. On the Master sheet I have a list of products each with a unique ordering part #. On my sheet named Add I have a list that gets generated by ordering part number...

Hi Have have below code, but even if there are no errors its displaying err: Sub ref() On Error GoTo err Application.ScreenUpdating = False ActiveSheet.Unprotect Password:="htc" ActiveWorkbook.UpdateLink Name:= _ "C:\Documents and Settings\OpsTL1\My...