Re: array
- From: SteveDB1 <SteveDB1@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 29 Aug 2008 10:30:01 -0700
Hi Dave,
as always... you're good! Thank you so very much.
now for the second part.
My second issue is that while the second element in my array is always
constant, the first is not. I would like to set up a variable name for the
first and thought that an if/elseif function would help that. however, I'm
not clear on how I should accomplish that.
"Dave Peterson" wrote:
Maybe....
Sheets(Array("SUM", "APN")).Copy _
after:=Workbooks("TROABook.xlsx") _
.sheets(workbooks("TROABook.xlsx").sheets.count)
You want to make sure that you're counting the sheets/worksheets in the right
workbook.
SteveDB1 wrote:
hi all.
I recorded a macro to copy two worksheets with specific names from an open
workbook to a workbook with a specific name.
I then looked at the code it made, and saw that I got the following.
Sheets(Array("SUM", "APN")).Select
Sheets(Array("SUM", "APN")).Copy
Before:=Workbooks_("TROABook.xlsx").sheets(65)
The first thing is that I wanted it to copy the worksheets to the end of the
book.
I've tried setting the code to copy After, and changing sheets(65) to
worksheets.count, as well as sheets.count. It rejects both, stating that
"copy method of sheets class failed.
My second issue is that while the second element in my array is always
constant, the first is not.
I would like to set up a variable name for the first and thought that an
if/elseif function would help that.
however, I'm not clear on how I should accomplish that.
--
Dave Peterson
- Prev by Date: seasonal adjustment
- Next by Date: Do Loops
- Previous by thread: Re: array
- Next by thread: seasonal adjustment
- Index(es):
Relevant Pages
|
