paste in hidden sheet

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


--
Thanks
Shawn

yes. assume Sheet 3 is hidden:
Sheets("Sheet1").Range("A1").Copy Sheets("Sheet3").Range("A1")

Charles

Shawn wrote:
> Can I paste something via VBA into a hidden worksheet without first unhiding
> it?
>
>
> --
> Thanks
> Shawn

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