On Jun 9, 11:51*am, "Rick Rothstein"
wrote:
One last thing, can you recommend a good book for VBA
Excel which has the syntax for all functions and commands?

The VB help files are your best bet for that. Go into the VB editor and
click...

* * *Help/Microsoft Visual Basic Help

on its menu bar. A "Table of Contents" dialog box will open up. Click on....

* * *Microsoft Visual Basic Documentation

in the listing, then click on...

* * *Visual Basic Language Reference

in the listing that opened up. In the next list that opened up is all the
language elements available in VB... just click to explore what you want and
the syntax is available for each. If you ever need to look up a specific
item, there is a short-cut to get to the help file for it. If you have the
key word in a code listing already, just put your text cursor anywhere on or
next to that key word and press F1... the help file for that individual item
will open up. If you do not have it in a listing anywhere, just type the key
word into the Immediate Window, make sure your text cursor is on or next to
the key word and, again, press F1.

Rick Rothstein (MVP - Excel)

Many thanks for the information.