ExcelBanter - paste in hidden sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - paste in hidden sheet (https://www.excelbanter.com/excel-programming/370579-paste-hidden-sheet.html)

Shawn

paste in hidden sheet

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

--
Thanks
Shawn

Die_Another_Day

paste in hidden sheet

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

Jim Thomlinson

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

All times are GMT +1. The time now is 10:34 AM.