programing reference for excel sprdsht

[chicopee]

Can any body suggest a reference book about programming excel spreadsheets. This book should show how to do loops, sub routines, go to, conditional statements. Please don't suggest MS Office as it is deficient in the areas mentioned above.

 

[pmover]

i highly recommend any book written by john walkenbach. his web site is located at:

http://www.j-walk.com/ss/

and there are several links to other knowledgeable excel, vba, etc. wizards.
-pmover

 

[mkoijn]

"Writing Excel macros" by Steven Roman is a very good introduction to vba programming.

 

[plawrence]

Another very good tool is the macro recorder. If you're slightly familiar with any programming language, you'll probably start to figure out how the Visual Basic Editor (VBE) pieces together the VBA. Go to Tools>Macros>Record (or something like that), record something simple like moving one cell to the left, stop the macro, then go to the VBE to see how it pieced it together.

Patrick