Thread: Error in Range Statement
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
  
Posts: 1,758
Default Error in Range Statement
You may have missed one reply at your first post:
http://groups.google.co.uk/groups?th...apeXSPAM.c om



SHIPP wrote:

Does anyone know why this gives an error?

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

--
M. Shipp

--

Dave Peterson
Reply With QuoteReply With Quote