Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select Case Statement | Excel Worksheet Functions | |||
If Statement to select a letter | Excel Worksheet Functions | |||
SELECT statement | Excel Programming | |||
SQL Select statement with Date as | Excel Programming | |||
Adding SQL Select Statement | Excel Programming |