err handler

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

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

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

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

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

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

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

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