XL7: Can't Set Bookmarks When Variables Defined as String

ID: Q135241

The information in this article applies to:

Microsoft Excel for Windows 95, version 7.0

SUMMARY

When you assign a variable to a bookmark as a String data type, if you are using Data Access Objects (DAO) in a Visual Basic for Applications module, the following error message will be displayed:

   Not a valid bookmark.

WORKAROUND

To work around this problem, declare the variable assigned to the bookmark as a Variant data type, as in the following example:

   Dim MyBookMark As Variant

Additional query words: 7.00 dimmed dimension

Keywords          : kbprg xlwin 
Version           : 7.00
Platform          : WINDOWS

Last Reviewed: September 3, 1997