error handling

Hell all, This is my very first post here. I have a beginner's experience in Excel and I have encountered an issue that I wasn't able to find a solution for online. I am using a shared excel file that is a data entry form shared by 12 users. Each person gets in, fills information and hits a...

I have an excel where I have to check if an account is present in which of two account listings. Else, I have to go to the next account. The code I am using is: <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console'...

Morning guys, I have written a VBA procedure which loops through excel files in an array: in turn it opens the file, refreshes the data, saves the file and closes. I would like to write an error handler which stores the file which errored (copied from the loop iteration) and the error...

Hi everyone! I have prepared a VBA code that repeats a large number of times a structural analysis which is performed with the software Sap2000. It works perfectly well most of the time, however, sometimes the analysis suddenly stops with the message: Error 442: Connection to type library or...

Hi There, I am having trouble with finding what is actually wrong with my code in regards to a specific ELSE condition. It highlights the ELSE that is apparently not related to an IF statement. Unfortunately, I am the only one here that has a basic (maybe even very basic because I can't get...

Hi, I am wanting to use error handling in some code i have written but am unsure of how to do so. Basically I am importing webpages into excel using the unique numbers associated at the end of the webaddress. When it is trying to import a webpage with a number that doesn't exist I get Run-time...

Greetings, My situation is this, i want to have different error messages for an error that has the same error number. pls help thanks Sub CopyTemp() Dim WWcellname As String Dim Pcellname As String Dim Tcellname As String Dim Workshets As String Dim Workshets1 As String WWcellname =...

I think the code is fairly self-explanatory, but I'm trying to search for a number (VehNum) in a column (VehCol) and copy all of the rows with the same number in the that column to a new sheet. I'm receiving a "Run-time error 1004: Application-defined or object-defined error" in 14th line of...

hello, so there's a macro that our client started to develop for us (I realize that sounds a little bit crazy, but forget it) and now I am developing it as they do not want to do it anymore. what macro does is more or less sorting rows in descending order of manufacturing recommendation and...

Can someone explain to me why excel won't let me do this? What I want is for any of my three workbooks that might be open to be closed upon macro error. Testing this doesn't work as excel yells because during testing I don't open one file to make the error happen. Bunch of code that leads to...

Hi, I am writing a code in VBA using getpivotdata function. It is working fine untill the value does not exist. Dim pt As PivotTable Sheets("Pivot2").Select Set pt = ActiveSheet.PivotTables(1) Cells(2,1).Value = pt.GetPivotData("ID", "GCB", "1", "Gender", "F", "9 box...

Hi All, This is a question that was asked to me in an interview and I couldn't answer it. The question is say, your manager asked you to prepare a report using access database. While preparing the report you get an error. Now, how to detect what the error is and how to handle it? What should...

Mr. Excel - I'm getting an error in VBA Compile Error: can't find property or library. I know why I'm getting it, but does anyone know if this has an error #? And, can anyone tell me some error-handling code that I could have a MsgBox prompt display the message: "Incorrect credentials"...

Hi all, first time trying to tackle error handling to any real degree and I just wanted a few suggestions/tips. The below is the basic overview of my code for my errors. Not capturing them individually as of yet. I was wondering does the error handling carry propogate through called subs? Or do...

Hello everybody, I thought this forum or even Google could help me, but in fact I'm just getting wrong search results for slighty different topics. My problem is: I have a VBA-code that copies an Excel-sheet, saves it separately and sends it via MS Outlook. I'm working with Windows 7 and Excel...

Hey everyone, I have a task at my new job to create a searchable database of blueprints. Rather than using Sort/Filters and CTRL+F, I wanted to try to emulate a drop-down menu style search, such as looking for a car by selecting criteria and then having all the results display. In this case it's...

I have written code to export two tabs and rename the file and do other manipliation to the data which works fine as long as the user chooses Yes or No to the messages, but if they choose cancel after the first Yes, an error comes up. My Yes and No responses are working correctly, just the...

I have created a .xlam file with a tab named 'Tables' in the spreadsheet that contains named ranges that are passed into the various UDFs that I have created. If the value passed into the function through 'Table' or 'Table2' does not point to a valid named range the function returns the #VALUE...

My code imports stock historical data. Help would be appreciated in creating a way for a user know that they chose an invalid date when trying to import stock information from the internet. In cases where a user inputs a date before the stock existed, the current code returns blank fields. It'd...

i've got a formula that looks like this: =vlookup($A2,MASTER!$A$2:$E$125,3,false) te formula runs down the A collum pulling information. Problem i have is that other people with use this sheet and I want them to be able to add in information so i want to keep the formulas alive and just have...