failure

  1. E

    Formula Help - racheting

    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...
  2. M

    Finding a word in a cell and looking down that column and returning a result based on 2 pieces of criteria - Really stuck!

    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...
  3. S

    Formula to Extract Text (instead of using Text to Columns)

    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.
  4. R

    error Handling in loop "For"

    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 ...
  5. A

    VBA - Autofilter stops when criteria is missing

    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...
  6. S

    Extracting Table Data from Outlook to Excel

    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...
  7. D

    can't create a button from Personal.XLSB Excel VBA

    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"...
  8. W

    range population

    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...
  9. F

    Deleting rows if column contains...

    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...
  10. B

    System Error &h8000FFF(-2147418113) catastrophic error

    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...
  11. Y

    Code running different in PrivateSub Workbook_Open

    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...
  12. A

    Cannot Insert Column with VBA

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top