Error on select statement
 

I am working in Excel 97 and am getting a 1004 error - Application defined or
object defined error. The code is

Worksheets(strWrkSht).Range(Cells(2, 2), Cells(intCopyTo1,
intCopyTo)).Select

I have stepped through the code to determine the value of the variables:

intCopyTo1=211
intCopyTo = 6
strWrkSht=Master

All variables are accurate. Any help would be appreciated.
--
M. Shipp

Error on select statement
 

Try putting Master in quotes i.e. strWrkSht = "Master"

"SHIPP" wrote:

I am working in Excel 97 and am getting a 1004 error - Application defined or
object defined error. The code is

Worksheets(strWrkSht).Range(Cells(2, 2), Cells(intCopyTo1,
intCopyTo)).Select

I have stepped through the code to determine the value of the variables:

intCopyTo1=211
intCopyTo = 6
strWrkSht=Master

All variables are accurate. Any help would be appreciated.
--
M. Shipp

Error on select statement
 

That didn't work. Any additional help is greatly appreciated.

"Bob" wrote:

Try putting Master in quotes i.e. strWrkSht = "Master"

"SHIPP" wrote:

I am working in Excel 97 and am getting a 1004 error - Application defined or
object defined error. The code is

Worksheets(strWrkSht).Range(Cells(2, 2), Cells(intCopyTo1,
intCopyTo)).Select

I have stepped through the code to determine the value of the variables:

intCopyTo1=211
intCopyTo = 6
strWrkSht=Master

All variables are accurate. Any help would be appreciated.
--
M. Shipp

Error on select statement
 

I get this same error message if I try to run the macro while the active
worksheet is other than Master ( I think the select method only works on the
active workbook).

"SHIPP" wrote:

That didn't work. Any additional help is greatly appreciated.

"Bob" wrote:

Try putting Master in quotes i.e. strWrkSht = "Master"

"SHIPP" wrote:

I am working in Excel 97 and am getting a 1004 error - Application defined or
object defined error. The code is

Worksheets(strWrkSht).Range(Cells(2, 2), Cells(intCopyTo1,
intCopyTo)).Select

I have stepped through the code to determine the value of the variables:

intCopyTo1=211
intCopyTo = 6
strWrkSht=Master

All variables are accurate. Any help would be appreciated.
--
M. Shipp

Error on select statement
 

You can only select a range if its worksheet is active/selected.

so one way...

with worksheets(strWrkSht)
.select
.range(.cells(2,2),.cells(intCopyTo1,intCopyTo)).s elect
end with

But maybe you could just do what ever you had to do to that range without
selecting it:

with worksheets(strWrkSht)
'.select
.range(.cells(2,2),.cells(intCopyTo1,intCopyTo)).c learcontents
end with


Note the additional dots in front of the .cells(). This means that this object
belongs to the object in the previous With statement.


SHIPP wrote:

I am working in Excel 97 and am getting a 1004 error - Application defined or
object defined error. The code is

Worksheets(strWrkSht).Range(Cells(2, 2), Cells(intCopyTo1,
intCopyTo)).Select

I have stepped through the code to determine the value of the variables:

intCopyTo1=211
intCopyTo = 6
strWrkSht=Master

All variables are accurate. Any help would be appreciated.
--
M. Shipp

--

Dave Peterson