paste in hidden sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I paste something via VBA into a hidden worksheet without first unhiding
it?
 
yes. assume Sheet 3 is hidden:
Sheets("Sheet1").Range("A1").Copy Sheets("Sheet3").Range("A1")

Charles
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slow Code 2
Identify Hidden Columns - New issue! 19
file path or IP address protected 1
unprotect hidden sheet 2
copy text and logo from protected, hidden sheet 1
How to copy Range and Paste as Values (from hidden sheet) 2
Hidden rows 1
Need a macro 3

Back
Top