View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Cut and paste cells

With Sheets("Ready")
.Range(.Cells(2,1,),.Cells(ReadyRows-1,11)).cut
End With

--
Regards,
Tom Ogilvy


Jesse Hamilton wrote in message
news:wfVrb.12590$Ws6.9472@edtnps84...
I have a line of code in one of my sheets

Sheets("Ready").Range(Cells(2,1,),Cells(ReadyRows-1,11)).cut

But it only works if the sheet is active, I want it to work without the
sheet being active hence I want to avoid using Sheets("Ready").Activate

Any help?

Jesse
jesse at jesseh.net