Im trying to debug code i havent wrote myself:
A range is set to something that the program seemes to find. When watching the range.value it returns the correct value.
The program is using commandbars and commandbarpopups which im not known to at all.
cmbMenu is a commandbarpopup and rngmenu a range.![]()
With cmbMenu .Caption = rngMenu.Value .DescriptionText = rngMenu.Value & " Menu" End With
rngmenu.value returns "&mallmeny"
Runtime error .. 20028018: Method value of object range failed
Bookmarks