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: dimmed dimension

Keywords : kbprg xlwin
Version : WINDOWS:7.0
Platform : WINDOWS
Issue type :