err handler

  1. D

    Selection.Find Run time error 91?

    Hi All, Hope you are all well! I'm struggling to overcome the error in relation to the below code, would anyone be able to help me out? Basically I keep getting the 'Run time error 91' for the bolded section of the below code. In the below I'm searching Column E for the value "4" and if/once...
  2. V

    List all files in server or folder using Dir

    Hi Excel Experts, This is my first post and sorry if there are any mistakes or not conform to rules while asking question. I thank everyone for making this forum a general one as many people can view the questions and learn excel. I work in excel and I want to extend the discussions of the 2...
  3. S

    Error handling in vba

    Hi all, Please find below some code that I've pulled together. I have 2 questions: 1. What I would like to see happen is that when an invalid date is entered that after the error message pops up is that the code resumes from where the user is asked to enter the date details. How can I ge...
  4. H

    Hyperlink Macro Loop with Error Handling????

    OK, for some reason (someone probably knows why) when I use the macro below to add a hyperlink to all cells in one column of a table the loop will reach a value that is just numbers and spit out an error. the values in the cells are the names of other worksheets in the file. and the values are...
  5. D

    need ErrHandling after no search result Notepad

    Hi All, I am a newbie on macro's and still learning :cool:. Hope you can help me out. I have a working sendkeys macro. Accept for one part that I can't figure out; ErrHandler1. Problem: No search result error from notepad if text is not present in notepad file Solution looking for: if no...
  6. cgeorge4

    MACRO PROBLEM: How to add error handling if pivot table already exists on sheet

    Using Excel 2007 at home / Excel 2010 at work Window 7 The code below is a recorded code that creates a pivot table on the same sheet as the data. I added and changed some lines of code where necessary with no problem. PROBLEM: I'm not sure where to place the first "error handling" line of...
  7. A

    Do While Sytax

    Hi all , I wrote code that works just fine, however, I realized there were parts of the data I was using that had 0's in it for holiday. Bottom line, this is code that calculated the weighted average of prices for 12 months (12 rows across) and Drows across. I'm trying to use the "do while is...
  8. O

    Macro copy paste from two tables

    Hi Guys I have this code: With mybook.Sheets("list") Set sourceRange = .Range("A1:b1000") End With Can anyone help me change it so that if it doesn't find sheet'List' it copies column 4 & 7 from table 1, and columns 4 & 7 from table 2...

Watch MrExcel Video

This Week's Hot Topics

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
Top