| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
EXCEL command or syntax
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
EXCEL command or syntax
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" wrote in message oups.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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
EXCEL command or syntax
Thanks for the hlp
"Mark Bigelow" wrote in message oups.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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
EXCEL command or syntax
Pressing the F1 was what did it for me..Many thanks
"Tom Ogilvy" wrote in message ... 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" wrote in message oups.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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vba syntax for excel object | Excel Discussion (Misc queries) | |||
| Excel Rank syntax | Excel Worksheet Functions | |||
| Syntax for Excel variable using a SQL Select/From/Where Command... | Excel Programming | |||
| Command text syntax and comma | Excel Programming | |||
| Correct syntax for use Replace command via DDE? | Excel Programming | |||
Linear Mode
