run-time error '91'

Hello Everyone, I have encounter a strange situation, the codes that i have below sometime runs without any error message, but sometime it gives me a Run-Time Error '91': Object variable or With block variable not set Can someone please help to explain why this happens and what can i do to...

Hi Folks, Happy new year to everyone. Please would you be willing to help me with a puzzling error message resulting from my AutoFilter VBA code. Here are the steps I'm asking the VBA to follow: 1) AutoFilter on column 4 to return only N/A. 2) Select first returned cell and then select all...

Hi guys, so i keep getting an error saying "Object variable or with block variable not set" the code used to work perfectly before i added something what i added was Set rng = Range(Range("A1"), Range("A1").SpecialCells(xlLastCell)) Set tbl = ActiveSheet.ListObjects.Add(xlSrcRange, rng...

With Sheets("Sheet2"): Dim Rng As Range: Set Rng = .Range("Sheet2!A:A"): End With Dim lngDateRow As Long, vFromDate As Variant: vFromDate = Range("Sheet1!B5").Value With Sheets("Sheet2"): lngDateRow = Rng.Find(What:=vFromDate , LookIn:=xlValues, LookAt:=xlWhole...

Hey all, I'm hoping someone can help me with the issue I'm having. I have a macro that does a bunch of stuff on several tabs in an excel worksheet. One part of the macro creates 2 subtotals and then hightlights and bolds the total lines for each. The subtotal is grouped by column L and summed...

So basically I am at the final stages of creating an excel spreadsheet that generates the fiscal month based on the date give and will assign different tasks to various groups based on the day. I am almost finished the calendar portion but am having a problem in this section 'Below is the...

I copied what looked like an easy macro form a website. The macro works perfectly with the worksheet I downloaded, but when try to utilize the macro in my worksheet I receive a Run-time error. code from website: Private Sub Worksheet_Activate() For i = 1 To 10 Sheets("Names").Cells(i...

Hello guys I am so frustrated. 2 days trying to decipher this. I have emailed a spreadsheet to all my internal customers and they all get the same error "Run-time error 91: Object Variable or with block variable not set" We all work on Excel 2010... so I don't think that's the problem When...

All, I am trying to find a method for converting all cells in entire workbook starting with the formula "=cc." to values. This is what I have so far. Sub Do Until IsNotFound Cells.Find(What:="=cc.", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart...

when I open up the spread sheet aiiwwaxexcel0 the code runs fine and all is good but if I open up any other or new workbook I get this run time error any ideas? code below 'Private Sub Workbook_Open() 'Select Case ActiveWorkbook.Sheets("aiiwwaxexcel0").Range("A3").Value 'Case "History"...

I am using Office 2010. Opening the workbook works fine when not in Protected View. However, anytime it is in Protected View (opening from email) the user gets the following error after clicking Enable Editing: Run-time error '91': Object variable or With block variable not set I ran the...

Hey everyone, I am having some trouble with this one. I am finishing up a very large VBA. There are three instances where I select a column, search for a particular word (i.e.- "MOVE") and select that cell. That works perfect. The problem is when the word is not found. Once in a while, that...

Hi All, I've been using the following code successfully and this is it's function: It copies some values from one sheet to another, then looks for a value (0,1 or 2) in Column A of the ("Environment Information") worksheet and then copies a specified row from the ("Format Control"). sheet...