With object must be user-defined type, Object, or Variant

  • Article

The With...End With block can't be used with allvariable types. This error has the following cause and solution:

  • You tried to use a variable that was not of Object type, user-defined type, or Variant type containing an object within a With block.

    Check to see if you misspelled the name of the object, user-defined type, or Variant variable.

For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.