I think it is more to how we interpreted the question. If you want pure VBA
reference (but why, VB/VBA is so simple, and there is help), the Lomax's
book is better. But as the guy is posting in an Excel group, I figured he is
interested more in Excel VB add-ons, hence the Programmers Reference wins
hands down (in fact there is no contest, Lomax doesn't even touch Excel).

As for buying a book because it lays better on the desk, well ...

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNET wrote in message
...
Interesting. This is where our individual needs drive our usage. When I
think of a reference book, I think of very quickly being able to find a
place in the book that explains something. VB/VBA Nutshell, being
organized in alphabetical order kind of like a dictionary, enables that.
It also has "perfect binding" (at least my old copy does), where it lays
flat on my desk and *stays put* when I am reading and typing. The Wrox
books don't. They require 2 hands to hold, look for a page, hold it open
with elbows and hopefully not crack the spine. Actually I ended up
cracking the spines of both of them through normal usage. My estimation of
what makes a good book includes construction, indexing, page notations,
font, paper quality, etc. As well as writing.

Guess the OP's going to have to see what works for him!


--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"Bob Phillips" wrote in message
...
I prefer Excel VBA Programmers Reference, Bullen, Bovey & Green. I have
the 2000 version, avoid the 2003 version like the plague. There is a 2007
version which I have not seen.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNET wrote in message
...
VB and VBA In A Nutshell by Paul Lomax. IMO best "reference" book out
there.

--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility



"Ed" wrote in message
...
Can anyone recommend the most comprehensive book to reference for
VBA?

Thanks


Ed