Object variable or with block variable not set

[rshinn]

Hello,

I get the following compile error when I try to run the following code:

Set cb = CommandBars.Add(Name:="Bookkeeper Helper", Position:=msoBarFloating)

Runtime error 91 Object variable or with block variable not set

Thank you for the help.

Richard

[Bob Phillips]

What have you declared cb as?

[rshinn]

Hi Nihil,

I've declared cb as follows:

Dim cb As CommandBar

Thank you.

Richard

[Bob Phillips]

No thoughts, it works fine for me.