runtime 91 error

Hey guys, Just wondering, I keep getting error 91 when running the below: Sub HighlightCellIfValueExistsinAnotherColumn() Dim ws As Worksheet Dim i As Long Dim j As Long Dim LastRow As Long Dim LastRow2 As Long LastRow = Cells(Rows.Count, "Q").End(xlUp).Row LastRow2 =...

Hi, i am having trouble with my code. Im getting a runtime error 91. Could you tell me whats wrong? Thanks. Sub Send_Mail_Esk() Dim emailApplication As Object Dim emailItem As Object Dim strPath As String Dim lngPos As Long strPath = ActiveWorkbook.FullName...

Hello community, I have a code that I would like to run when an excel file is being opened. To stress it out - I would like to run the code when any excel file is run, not a specific one (nevermind what the code does) So, I need to do two main things: 1.: Insert the code in Private Sub...

Hi, I am writing the following code which allows me to proceed to a website that I need to gather info from to then export into excel. I am very new to HTML web scraping with VBA and I am currently writing it line by line and testing it as I go. Sub GoToMarketingScents() 'navigate to...

Hello, I can't figure out what is going on. I am a relatively new VBA programmer. Long story short, I have an input userform called by a macro attached to a button on the spreadsheet. It works perfectly. I also have a userform to allow someone to sort over multiple spreadsheets at once, and...

Hi All, I've the below code which does the trick but I get a runtime error 91 on the last line starting with "tbl" . I've used on error resume and it will happily work, but this is ofcourse not the answer. I believe the error lies in the fact that the data body range will be empty following the...

Hi all. I hope you can help I have a piece of code that is producing a run time error 91 I am trying to get a MsgBox to tell me if there is a sheet in my workbook called "In Progress" or else that is not in my workbook but it is creating an error on this line If worksheet.sheet.name = "In...

Hi, I have a query regarding my code. I am not sure why am I getting this error when I am calling another macro. I found out that when I am at the MasterData sheet macro works fine. I suspect it there is some discrepancy with the find function and I like to know why. The highlighted debug...

I am running the following code on one of my worksheets ("Deal Info" / Sheet3) however for some reason one of the users of this workbook is getting a Run-time error '91': Object variable or With block variable not set message when they open another workbook and this one is open. Here is the...

Macro - Run Time 91 Error Hi, I have an excel document that is linked to access, and a macro runs to refresh all of the links and the pivots in excel that run off the data. My spreadsheet was working fine, and refreshing, but now when I run the Macro to refresh everything I get a Run Time...