Results 1 to 2 of 2
Thread: Copy & Paste a range
2002-08-14, 21:56 #1
- Join Date
- Aug 2002
- Thanked 0 Times in 0 Posts
Copy & Paste a range
Anyone out there use VBA for Applications? If so what command, when writing a macro, allows you to select a range of values including some formulas then paste into another range I choose. I have tried to figure it out to no avail. The only way I see it working is to paste into the same cell all the time?
2002-08-14, 22:36 #2
- Join Date
- Dec 2000
- Salt Lake City, Utah, USA
- Thanked 6 Times in 6 Posts
Re: Copy & Paste a range
The Copy Method (edited) from the XL2k VBA Help File
Syntax 2: Copies the Range to the specified range or to the Clipboard.
expression Required. An expression that returns an object in the Applies To list.
Destination Optional Variant. Specifies the new range to which the specified range will be copied. If this argument is omitted, Microsoft Excel copies the range to the Clipboard.
So you might copy and paste with a command such as:
Worksheets("Sheet1").Range("MyNamedSourceRange").C opy Worksheets("Sheet2").Range("A1")
this one line will copy the content of "MyNamedSourceRange" in Sheet1, whatever size it may be, to the corresponding range starting in cell A1 in worksheet Sheet 2.-John ... I float in liquid gardens