object reference

  1. szita2000

    VBA - Shared file. Two users with different versions of Outlook

    Hi guys. I created a file with rondebruin-s emailing code. I have some issues as it is a shared file that two user uses, and I am getting reference errors One of the user uses Microsoft Outlook 16.0 Object Library the other one uses 15.0. Is there a way to code this so the reference will...
  2. G

    What is the object reference

    I have one of those fancy programs that helps me write VBA. I want to write code that will set DisplayZeroes to false. This program suggests the following code Dim wsvw As WorksheetView: Set wsvw = wsvw.DisplayZeros = False I am unsure how to complete the Set statement (requiring the...
  3. O

    Find/replace in Word from Excel VBA - not working (possible Object Library problem)

    Hi all, have searched a lot to find a solution, hope some can verify what my problem is and how to solve it. I want to search/replace text in a Word doc from Excel. This should be plain sailing, multiple solutions exist online. However, I can only find the text, and fill the replace dialogue...
  4. D

    Error "Couldn't get data from the Data Model"

    I keep getting the following error when I try to refresh a pivot table (not Power Pivot). "We couldn't get data from the Data Model. Object reference not set to an instance of an object". I tried re-selecting the data source, but would get the same error message. I checked to see that I have...
  5. J

    Referencing position of a Text Box

    I've built a visual containing several text boxes that have the names of activities typed into them. These text boxes are in a kind of table that has five defined rows (each row pertains to a particular resource used), and columns that depict when these activities will happen in relation to the...
  6. J

    Problem executing public subroutine!

    I have two different forms (Class1 and Class2) which are similar and both of them have object ComboBox1. Because these ComboBoxes have same list of values I created Public subroutine in one of Modules to run certain macro when certain value from ComboBox is selected: Public Sub RunMacro1...
  7. U

    Reference Not Set Error

    I am getting the dreaded "Object reference not set to an instance of an object" error on the following code. The code hangs on the ".send" line, but I haven't been able to figure out why. Furthermore, it only hange on some users computers, not all (not mine, of course, which makes...

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