thanks for both of your comments,,, however i have to agree more with bob
that the help files arnt really much use to me at the moment,, id do use them
as a refrence sometimes but in general im better of with the refrence guide
which will tell me what things can do,, rather than how to make them do it

thanks to both of you


"Bob Phillips" wrote:

Take a look at the VBA 2002 Programmers Reference. Here is what I once wrote
about it

Synopsis This book presents a full reference to the Excel object model,
which is essentially the object-oriented system of organizing the functional
capacities that make up the Excel program. There is a short introduction to
VBA itself, and the rest of the book documents aspects of programming Excel
through that object model.

Level: Intermediate/Advanced

My view: The only 'Excel' book in the list. In my view there are not many
good Excel books around, too many re-hash the same old stuff which most
intelligent Excel users are perfectly capable of acquiring from their own
skills. But this one goes beyond all of that, it's about programming. I
often say to people that VB is easy, it's understanding the various object
models that is difficult and where the power lies. This book takes you
through the Excel object model, and show you many great techniques to
harness it for your code. The Object Model Reference is quite handy too!

Be careful to get the 2002 version though, maybe from eBay. There is a 2003
edit, but that was very poorly done IMO, and makes it less useful than its
predecessor.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rich Mcc" (no spam) wrote in message
...
am looking for a vba refrence book .. rather than a idiots guide ..

i.e one that list the various "codes" and what their options are,, rather
than a set of pre built programs

and ideal would be apreciated