Excel VBA Looking for Good Book or WEB site that has examples

[DougP]

I know the BASIC language very well.
I know Access very very well but I don't know how to refer to cells and so on in Excel. the intericacies of how to get a cell and move over 2 cells a copy it, or get infor from one cell and paste it over one column and down to the next 12 cells.
I need a comprehensive list of Excel VBA code commands


DougP

 

[mscallisto]

I started with "Excel Power Programming with VBA" by John Walkenbach.

I actually sat down and read the 1,000+ pages and tried each example that interested me (took a while but worth it)

I probably have 50 post-it's marking pages of particular interest and refer the book often.

I have the 2003 version that cost $49 in 2004 but found it to be well worth the price.

If you think that's too expensive then may I suggest a visit to the book store and search for a book that may suit your needs for less money.

I also believe in simply trying VBA coding using the excel help that isn't always easy to read at first but gets easier after a while.

Good Luck

sam