1. D

    VBA RegEx match with input box

    Hi, Is it possible to match and Input box answer against RegEx so Special characters are used, can someone help please? This is what I have so far Dim MyStr As String, addStr As String, RegEx As Object On Error Resume Next addStr = InputBox("Cells...", "Enter Character") Set...
  2. M

    VBA Error Run TIme Error 424

    I am working on a very large Geneology project. I want my code to update given fields in my data sheet. My code is looking to see if the given person has a previous marriage. If it doesnt that it should continue with the code. I am using "On Error Resume Next" but it still breaks in my line and...
  3. P

    VBA - Cant Exit errorhandler

    I know I have error after resume, but it won't trigger. Why won´t Resume exit the error handler On Error Resume Next cap = QUL_Import_Form.CAPnr file = QUL_Import_Form.Anlnr If Err.Number = 13 Or cap = 0 Then MsgBox "Felaktig data har angivits...
  4. L

    Error handling question: if sheet doesn't exist, go to

    Hello, I have the codes below to basically copy and paste some data from one workbook (book23) to other workbooks. the problem is that sheet "WDed15" may not exist. Can someone show me how to add an if statement to test if sheet("WDed15") exists, if it does, continue to execute the entire...
  5. T

    Error handling in a loop

    Which of the two methods below are preferable? Method1 with error handling: Sub Start() On Error GoTo Errhandler For Counter = 1 To 1000 i = 1 Do Until TableArray(i, 1) = MyArray(j, 1) i = i + 1...
  6. D

    Right Click Insert Button Not Removing vba

    Hi, I am having an issue where the Insert... Function is not being removed when I open Excel, However if i run through it manually it will remove it. Doesn't make sense because I have checked the Spelling to match the right click button. See code below Private Sub Workbook_Open()...
  7. E

    VBA Loop for Column select from input box

    I have a input box to select the column with the dates thenwhere I want to put the time span into words. I am trying to use a loop to enter formula down the column but keep getting error's [CODE]Sub DateSpan2Words() Dim DateNumCol As Integer Dim TimeSpanCol As Integer Dim isnumber As Long Dim...
  8. Vally 88

    VBA not breaking but not working

    Hello All, I'm trying to create a Hide- show VBA based on *name* for different tabs. Please find code below: Sub hide_Arabic_tabs() For Each ws In ActiveWorkbook.Worksheets On Error Resume Next Select Case True Case LCase(ws.Name) Like "*Arabic*"...
  9. M

    Run Macro on Click

    Hi. First post here. I tried searching, but did not see anything (I may not have used the proper search terms). I am new to the VBA game. I have a macro using the MonthView form. It is triggered by a keyboard shortcut: Private Sub Workbook_BeforeClose(Cancel As Boolean) On Error Resume...
  10. R

    Next without For

    Private Sub EnterButton_Click() Dim MyPoNum As Long Dim MyDate As Date Dim MyQty As Long Dim MyPNum As String Dim MyRow As Long Dim cmb As combobox, i As Integer For i = 1 To 10 Set cmb = Me.Controls.Item("ComboBox" & i) MyPoNum = Me.txt_PoNum.Value MyDate = Me.txt_Date.Value...
  11. RobbieC

    Error message handling and resuming...

    Hi there, I have a macro which I need to try and debug... I can identify the various errors, but is it possible to resume the macro if certain errors are picked up? I can then weed out which errors are the issues and tend to them applicably. This is the code I have so far: On Error GoTo...
  12. K

    VBA Macro not working after move form 2010 to 2016

    Hi, I've got a problem with a macro on one of my worksheets not working since I moved from Excel 2010 to 2016 this morning. The macro is designed to auto-sort data by column F: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Not Intersect(Target, Range("F:F")) Is...
  13. S

    Error 20 after a match function

    After a successful match I get the row number and move to the else statement, but somehow I'm getting an error 20. My search indicates I have a resume outside an error handling routine. I just don't see it. Your insight is appreciated. On Error Resume Next...
  14. FracinDean

    Controlling AutoFilter

    I reviewed 15-20 posts and tried a lot of different options, but I'm still having trouble. I'm trying to accomplish two tasks: 1) Turn off Autofilter only if it's on, and 2) Turn AutoFilter on for the specified range in a single worksheet. I only need to manipulate AutoFilter on the sheet...
  15. R

    Continue Macro after opening file

    Hello everyone. Does anyone know if it's possible to make a macro continue only after opening another file, and if so, how to do it? The idea is that when the explorer opens the folder (this part works), i open a chosen file, and only then the macro continues. Here's my code (don't worry...
  16. S

    Coding best practices for calling worksheet functions which may return an error?

    Hey all, So I just stumbled across an issue which I hadn't expected when processing certain datafiles with my VBA using the WorksheetFunction.AverageIf(). Evidently it's possible for me to process an array with this function call which may actually contain ONLY zeros, and hence throw an error...
  17. D

    Pause macro for input then resume?

    As powerful as EXCEL is, I am hard put to believe that there is no way to have a macro pause, wait for user input (ended with a carriage return [the ENTER key for you young pups]), then continue the macro. Simply put, I want the macro to select a cell, wait for input and an [ENTER] then continue...
  18. S

    Save UserForm and reopen later semi-complete and resume

    Hi, I have quite a long form that the users have stated they want to pause halfway and resume. I currently have the following code to save and close: End With ActiveWorkbook.SaveAs ([txtStudentLast]) ActiveWorkbook.Close End Sub but when I reopen it the data is written to the background sheet...
  19. M

    Career in BI.. Whats next for the resume?

    looking for some advice.. im a CPA that has made a career in Excel.. now that im hooked on PowerPivot and DAX,id like to move further from Acct and closer to a career in BI. i habe lots of Excel (heavy logical formulas and pivot), navigate well in PP (pivot, maps)... whats the next skill to add...
  20. C

    Excel similarities and differences to SAS/SPSS

    Okay, so I currently work in the financial profession, and through this I discovered my knack for/love of MS Excel. I feel very confident in my abilities having built several financial calculators and models that many members of my office use and enjoy. My problem is that I'm moving and I'm...

Some videos you may like

This Week's Hot Topics

  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • Highlight Row and Column on cell selection
    In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple...
  • Need Numbers Inputted and Deleted
    Thanks for your help. Not sure if there is even an = equation for this. Please see attachment. If there is a solution, please respond with = So...
  • Worksheets(x).Select Error
    Hi, I am trying to select multiple sheets using the following code. [CODE=vba] Dim x As Integer ThisWorkbook.Worksheets(3).Select...
  • myFind Range not working
    Please can someone say why this myFindRng goes red in the code? [CODE=vba]Private Sub Model_Chose_Change() With ThisWorkbook.Worksheets("Job...
  • How to identify the last page break in a sheet
    How can I find the position of the last page break in my sheet? There may be multiple pages and I want to know how to find the position of the...

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