| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste in hidden sheet
Can I paste something via VBA into a hidden worksheet without first unhiding
it? -- Thanks Shawn |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and Paste with hidden columns remaining hidden | Excel Discussion (Misc queries) | |||
| copy/paste with hidden rows don't want hidden parts to paste | Excel Discussion (Misc queries) | |||
| How to paste data over the hidden rows in a sheet with a filter | Excel Discussion (Misc queries) | |||
| paste excel sheet excluding hidden rows | Excel Discussion (Misc queries) | |||
| Excel: copy and paste only shown not hidden cells into new sheet | Excel Discussion (Misc queries) | |||
Linear Mode
