Visual Basic for Applications Reference
Most properties only accept values of a certain type, within a certain range. This error has the following cause and solution:
- An inappropriate value has been assigned to a property.
See the property's Help topic to determine what types and range of values are appropriate for the property.
For additional information, select the item in question and press F1.