|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 05:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com