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.

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


"Michael Vaughan" wrote:

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.