EXCEL command or syntax

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

--
Norton Professional 2004 says this email is clean...believe it

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

PCOR wrote:
> 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
>
> --
> Norton Professional 2004 says this email is clean...believe it

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....htm#tutorials

--
Regards,
Tom Ogilvy

"Mark Bigelow" <mjbigelow@hotmail.com> wrote in message
news:1110567914.100978.159890@f14g2000cwb.googlegroups.com...
> Check the microsoft developer's network (http://msdn.microsoft.com) or
> the object browser in VBA by pressing F2
>
> PCOR wrote:
> > 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
> >
> > --
> > Norton Professional 2004 says this email is clean...believe it
>

Thanks for the hlp
"Mark Bigelow" <mjbigelow@hotmail.com> wrote in message
news:1110567914.100978.159890@f14g2000cwb.googlegroups.com...
> Check the microsoft developer's network (http://msdn.microsoft.com) or
> the object browser in VBA by pressing F2
>
> PCOR wrote:
>> 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
>>
>> --
>> Norton Professional 2004 says this email is clean...believe it
>

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

"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:%23rMl4inJFHA.3076@tk2msftngp13.phx.gbl...
> 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....htm#tutorials
>
> --
> Regards,
> Tom Ogilvy
>
> "Mark Bigelow" <mjbigelow@hotmail.com> wrote in message
> news:1110567914.100978.159890@f14g2000cwb.googlegroups.com...
>> Check the microsoft developer's network (http://msdn.microsoft.com) or
>> the object browser in VBA by pressing F2
>>
>> PCOR wrote:
>> > 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
>> >
>> > --
>> > Norton Professional 2004 says this email is clean...believe it
>>
>
>