View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.programming
dolsen dolsen is offline
external usenet poster
 
Posts: 9
Default LCase function gives an error

Okay, I see, CommandBars not CommandBar. I am using Application.CommandBars.
I still get the following error:

Run-time error '-2147467259 (80004005)':
Method 'PasteFace' of object '_CommandBarButton' failed

Any other ideas for me?

"Tom Ogilvy" wrote:

Application.CommandBars doesn't cause a type mismatch error.

--
Regards,
Tom Ogilvy



"dolsen" wrote in message
...
How will using application.Commandbars fix an error that is caused when I
use
application.Commandbars?