error '91'

  1. T

    Runtime Error '91' Object variable or With block variable not set

    Can someone help me fix my code. I am trying to loop through a column that has numbers beside each of the new files. For each i it should set the range as an offset 2 columns over and pull that file name, but when it loops through I get a runtime error '91' Then at the bottom I am trying to...
  2. N

    Find Function Error 91

    Hi, I am using the following code to find values in particular column, when the entered value is available in the particular column it is showing the particular rows in the list box. Now the problem is that if the value is not available it returning to the error 91. Private Sub...
  3. T

    error 91

    Below is the macro I use I search names and if they match I color them. Cells.FindNext(After:=ActiveCell).Activate Cells.Find(What:="mount zion", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False...
  4. G

    Object variable or With block variable not set (Word through Excel, VBA)

    Hey, I'm discovering VBA during my internship and there is no one at work who can really help me so I came here to ask for some explanations. In my procedure (Sub WordTreatment () ), the code stops running at the bold line and I don't really understand why. (Error : Object variable or With...

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
Back
Top