EXCEL command or syntax

[PCOR]

ActiveSheet.UsedRange.Copy Worksheets(2).Range("A1")
ActiveSheet.Range("A1").CurrentRegion.Copy Worksheets(2).Range("A1")
Above are just 2 examples. Cab someone tell me where I can find all/most
"command"such as "USEDRANGE" or "CURRENT REGION"
Is there a book a course or a place where I can attempt to become familiar
with a few..
Thanks

 

[Mark Bigelow]

Check the microsoft developer's network (http://msdn.microsoft.com) or
the object browser in VBA by pressing F2

 

[Tom Ogilvy]

The object browser (as suggested) used in conjunction with the help file in
the VBE are the best reference (highlight an item in the browser and hit F1
or click the help button). If you need a tutorial, perhaps a book by
someone like Reed Jacobson (MS Press) or John Walkenbach, or John
Green/Stephen Bullen.

David McRitchie has some links to tutorials:

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

 

[PCOR]

Thanks for the hlp

Check the microsoft developer's network (http://msdn.microsoft.com) or
the object browser in VBA by pressing F2

 

[PCOR]

Pressing the F1 was what did it for me..Many thanks