At a guess, you are refering the .Add method.
<From Help
Add Method (CommandBars Collection)
Creates a new command bar and adds it to the collection of command bars.
Returns a CommandBar object.
Syntax
expression.Add(Name, Position, MenuBar, Temporary)
expression Required. An expression that returns a CommandBars object.
Name Optional Variant. The name of the new command bar. If this
argument is omitted, a default name is assigned to the command bar (such as
"Custom 1").
...... etc
</From Help

As in the explanation, "Optional" refers to the fact that you do not have
the supply this argument. If you do, then it is used for the Name, if not, a
default is supplied.
As for the "Variant" part, you can basically supply an data type, as long as
it's value can be coerced into a valid value for Name.

NickHK

"Desert Piranha"
<Desert.Piranha.2cyj1w_1156276511.5348@excelforu m-nospam.com wrote in
message news:Desert.Piranha.2cyj1w_1156276511.5348@excelfo rum-nospam.com...

Hi all,

I have looked at help etc, but nothing there i can undestand.

Can i get some info on what is 'Optional Variant" in connection with
CommandBars?

What does it do?

Pros and cons?


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=574363