Thread: Error in formula !! and I can't see why
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
micmacuk
 
Posts: n/a
Default Error in formula !! and I can't see why

I have found the solution....

Sheets("WeekData").Range(Sheets("WeekData").Cells( 500, 20),
Sheets("WeekData").Cells(540, 32)).Copy Destination:=ActiveCell


--
micmacuk
------------------------------------------------------------------------
micmacuk's Profile: http://www.excelforum.com/member.php...o&userid=33253
View this thread: http://www.excelforum.com/showthread...hreadid=533999

Reply With QuoteReply With Quote