Book Recommendation??

[Michael Vaughan]

Hello Everyone,

Is there a good book on the market that would explain all the commands and
codes for VBA such as:

Selection.NumberFormat = "General"
With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Names.Add Name:="Calendar", RefersTo:="=" &
Range("A1").CurrentRegion.Address
Range("A2").Select

It would probably help me out a lot more by looking it up then by relying on
all your good help.

 

[keepITcool]

VBA help is an excellent reference for the individual merits of each
property. Highlight the word, Press F1. I do it all the time.

Start by printing the Excel Object Model page (again in VBA help)
Stick it on the wall near your PC. It's a fantastic roadmap.

ALWAYS have the "Locals" window in VBE visible & locate the F9 button,
which sets breakpoints. This allows you to run your code and SEE what
your variables are and which values they have on a particular line in
your code.


Then goto Amazon and order

Walkenbach's Excel Power Programming
AND
Bovey's VBA Programmer's Reference.


Learn:
Variables & Scope.
String Manipulation
Range referencing.

Go back to page 1 and do it again until you TRULY understand those
fundamentals. (it will save you lot's of time later)


If you feel curious... Open the object browser and spend a 15 minutes
every day just browsing.. you'll need to do that for 1 year at least.

I can still do it and find new things


Enjoy!



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >