Microsoft KB Archive/135241

= Can't Set Bookmarks When Variables Defined as String =

Article ID: 135241

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q135241



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 XL7

Keywords: kbprogramming KB135241

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.