Accessing the VBA Help Menu

[Petecal]

I have always had a problem using the "Help" menu in Microsoft VB Editor to get anything useful.

For example, (using excel 2003) I wanted to find the structure and options to do a pastespecial (I wanted to paste just the formulas and I know I have done it before but I just had a BRAINBLANK). I clicked Help and Microsoft Visual Basic Help and got a search box. No matter what I tried I could not get it to show me the pastespecial method structure.

I went online, downloaded, and installed "Microsoft Office Excel 2003 Visual Basic Reference". I can then run the installed program "vbaxl10.chm". I get a search box, type in pastespecial and it goes right to the thing I want.

How do I get to the same information using the Help menu item in the VB editor? Or do I just have to run the .chm program every time?

Thanks In Advance,

Pete

 

[VoG]

In a module type

pastespecial

then click in that word and press F1. Any good?

 

[Petecal]

Yes, it certianly did. But for a very backhanded reason.

I guess it thought Help was not installed. When I hit f1 it said Help not installed and proceded to install it. However, before I could get the CD I noticed that it had already created a window with the desired information. So another part of Excel knew it was installed.

Anyway I put in the CD and let it continue the installation.

Now I can f1 on the item I want help for and will get the right information.


Thanks,

Only question, "Will it still love me tomorrow?"

Pete

P.S.
But I still can't get to it from the Help menu button.

 

[VoG]

Only question, "Will it still love me tomorrow?"

Only Excel knows