View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SHIPP SHIPP is offline
external usenet poster
 
Posts: 29
Default 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