View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default paste in hidden sheet

Yes. The trick is that you can not use selection as you can only select on
visible active sheets...

Sheets("Sheet1").Range("A1").Copy Destination:=Sheets("Sheet2").Range("B2")

This code does not do any selecting so it should work for you...
--
HTH...

Jim Thomlinson


"Shawn" wrote:

Can I paste something via VBA into a hidden worksheet without first unhiding
it?


--
Thanks
Shawn