run time error 91

  1. A

    Object variable or with block variable not set

    I have a worksheet I am trying to create a filter for. I recorded a macro with all of the filtering set to what I need. When I try to assign it to my ComboBox and run it I am getting a Run-Time Error 91 Object variable or with block variable not set. It is highlighting the section "...
  2. H

    Run Time Error 91 : Object Variable or with Block Variable not Set

    Option Explicit Sub Button1_Click() Dim wb As Workbook Dim ws As Worksheet Dim FarmerName() As String Dim PurchasedAmount() As Long Dim LastRow, NameRow, AmountRow As Long Dim i, j, k As Integer i = 1 j = 1 k = 1 Worksheets(1).Activate Range("F:F").NumberFormat = "General" LastRow =...
  3. L

    VBA Run Time Error .Find

    Hi All, I'm very new to VBA and try to resolve most of my problems through looking at everyone's helpful posts! however, this time I can't seem to figure it out. I am trying to find "TS" in a specific column and filter for those rows if available. If not available, I just want to exit the sub...
  4. S

    Run Time Error 91, Object Variable or With Block Variable Not Set

    Hey everyone, So I will spare you some of the smaller details, but I am basically writing a code that cycles through all sheets in a workbook, looks for a specific range and then copies and pastes it to another sheet accordingly. The trouble part of the code right now is right at the beginning...
  5. A

    Run time 91 error in VBA code

    Hello. I'm a novice when it comes to VBA coding, and I have a question about why I might be getting a run time 91 error with the following code, specifically the argument reading "Else MailDoc.Body = DiscMarker". Any help that can be provided will be greatly appreciated...
  6. M

    createpivottable cannot set

    Hi, I'm trying to create a pivottable on VBA , I've set my range and pivot cache but I cannot create pivot table, it shows = nothing when I watch its value. At the last row of the pasted code below I receive the error "Run Time error 91, Object Variable not set". I couldn't find what is wrong...
  7. T

    VBA Problem

    Hi, I have a basic piece of vba which changes the type of chart from a line chart to a column chart: Sub COLUMN_CHART() ' ActiveChart.ChartArea.Select ActiveChart.ChartType = xlColumnClustered End Sub The problem i am having is that if this is pressed its works fine. But, if i...
  8. S

    Clipboard data as variable in VBA

    Hi Mr Excel Gurus, I have the following details in workbook 1. <TABLE style="WIDTH: 322pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=430><COLGROUP><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><COL style="WIDTH: 62pt...
  9. M

    Help with Macro across worksheets and other errors

    Hi I need a little help with this macro I've been working on. Some of it is from ctrl key macros that I have recorded and a little help from the forum. I ultimately need to get this macro to work across all the sheets in the work book. But only one portion of it works across all the...
  10. B

    Code near completion, runtime error

    Hello, I have a large column of UPC numbers I wish to identify. This code is designed to enter a search for UPCs at http://www.upcdatabase.com/itemform.asp. Then it copies the url of the search results page and pastes it in Excel 2007 next to its matching UPC. The end result should be a column...
  11. B

    Broken Code Importing data from Internet Explorer

    Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> This code is designed to enter a search for UPCs at http://www.upcdatabase.com/itemform.asp. Then it copies the url of the search results page and pastes it in excel next to its matching...
  12. E

    I'm getting run-time error 91; what is wrong with my code?

    I am getting run-time error '91' when I run this. I click debug and the following line is highlighted in yellow: Columns(2).Find(what:="TOTAL COSTS").Select Is there anything wrong with my syntax? What am I doing wrong? Sub findTotalCosts2008() Dim c As Range Dim lookup...

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