I am thinking about buying H&S with Excel, but need to know if it has:

All the functions in the full Excel version?
Visual Basic for Excel, so I can write complex macros?

I have some macros already written, and intend to buy a commercial app which
plugs into Excel.

Bob