failure

I would really appreciate help with the following formula as I just can't get it to work. For each failure during a month I get charged 10 If I fail three months in a row I get charged and extra 50%, so 15 per failure. If I fail again in the next month I get an additional 50% on top, so it's...

Hello all, I am hoping someone can help me. There is a report that shows user files being backed upsuccessfully or not. In column D is the success status. If a backup fails it tries again up to 3 timesthat same day for each user. The data issorted by username and in date order. My example...

Hi, I need an excel formula to extract the text between characters "_" (underscore) Eg in Cell A1 : IN18059850_Plant_T0_1218_New Failure I need Column B1, C1, D1, E1, F1 to extract the text between '_' Help me to get the data.

Hi Y'all i know this is silly, but i can't figure it out. please help : for i = 1 to 2 on error goto ErrHandler 'my code here sheets("Panel1").range("A1").value = "Success" errHandler : sheets("Panel1").range("A1").value = "Failure" resume nextitiration nextitiration ...

Hi all, newish to VBA, but picking up quickly. Sometimes the value in the filter is not in the data, and causes my vba to bug out on me. I commented it out, but would like to write something that would allow the code to finish by ignoring the criteria if it is unavailable. With...

Ive been reading articles and posts on here about the possibility of moving data from tables in the body of emails in Outlook to an excel workbook using VBA, there are so many and none have a direct relationship to what I am trying to achieve so I thought I would post and see if I am just...

Hello, i have a strange issue with Personal.XLSB where it won't let me create a button from there. if i use the code below within the File instead of Personal it works every time. the code i am using is: ActiveSheet.Buttons.Add(47, 43, 41, 35).Select Selection.Name = "Test"...

Y'all have never let me down. I've looked in the forums and can't find anything specific on this, so here goes: I have a user form that documents failure modes from a drop down list. When the command button is pressed, I need it to populate ComboBox11 into the first empty cell between F40 and...

Hi all, My VBA skills are very limited. I have found the below code from another thread which I've copied and pasted into my coding, it has worked for me to a point. This currently deletes any rows where column T contains the phrase "Pending Failure". But I need to go a step further and it...

I have made a excel workbook with at couple og VBA and userforms. On my computer the workbook works completly fine, when i send the workbook to some of my colleagues it shows this failure: System Error &H8000FFFF (-21474181113) catastrophic error Out of memory Does anybody have a clue whats...

Hi All! This forum has been awesome for getting me started on VBA, I'm not a programmer and I had to pick this up now because the company that I'm working for has a really outdated system and we have to do a lot of Excel manipulation to get the files the way we need them. I appreciate any help...

Dear All I would greatly appreciate your help on this, because I am going crazy. I have a spreadsheet filled with data (no merged cells) and I created a macro to sort the spreadsheet. Everything was working perfectly, until I tried to insert a column using code at the beginning of the macro...