Very few books advocate using select statements beyond perhaps a short
introduction on using the macro recorder.

The usual recommendations are books by John Walkenbach (power programming
VBA series) and John Green/Stephen Bullen (Excel 2000 VBA Programmer's
Reference or replace 2000 with 2002).

John Walkenbach's site
http://www.j-walk.com/ss/excel
(also has a links page)


Stephen Bullen's Site:
http://www.bmsltd.co.uk/Excel/Default.htm

Both have links to pages describing their books.

A free resource:

http://support.microsoft.com/support...01/default.asp

Also, the Microsoft VBA Programmer's guide is on their MSDN website
http://msdn.microsoft.com

Some links at Dave McRitchies site
http://www.mvps.org/dmcritchie/excel/excel.htm

http://www.mvps.org/dmcritchie/excel/getstarted.htm

http://www.mvps.org/dmcritchie/excel....htm#tutorials

VBA tutorials are after the excel tutorials.

Also Chip Pearson has page after page of sample code for specific
activities:
http://www.cpearson.com/excel.htm
go to his pages index or his topics index.

The microsoft. knowledge base:

http://support.microsoft.com go to Advanced search and select excel for
windows.



--
Regards,
Tom Ogilvy

"J S" wrote in message ...
Does anybody know of any books/websites that deal with how to write very
fast VBA code? Particularly in excel? I have just written some code in
Excel
that has reached close to 3000 lines and it seems like I will be writing a
great deal more in the future, yet I know very little about how to write
efficient code! I'm not really talking about fancy sort algorithms and the
such but the more mundane basic stuff like avoiding unnecessary select
statements.

-J