View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
surotkin[_2_] surotkin[_2_] is offline
external usenet poster
 
Posts: 1
Default Why QUIT method doesn't work after COPY method?


Hi Tom Ogilvy and Conrad,
thanks for responses.

I started with Tom's recommendation.
It works.
I felt there is a ghost (unreleasable reference) to Excel in my code.

I use full reference now:
ws_source.Range(ws_source.Cells(1, 1), ws_source.Cells(10, 20)).Copy

instead of:
ws_source.Range(Cells(1, 1), Cells(10, 20)).Copy

It made my code working properly.

Many thanks.

surotki

--
surotki
-----------------------------------------------------------------------
surotkin's Profile: http://www.excelforum.com/member.php...fo&userid=2119
View this thread: http://www.excelforum.com/showthread.php?threadid=47943