Paste to all sheets except some with criteria
Solved/Closed
nzstorm
Posts
6
Registration date
Thursday December 8, 2011
Status
Member
Last seen
February 3, 2013
-
Dec 27, 2011 at 11:46 AM
nzstorm Posts 6 Registration date Thursday December 8, 2011 Status Member Last seen February 3, 2013 - Dec 28, 2011 at 09:00 AM
nzstorm Posts 6 Registration date Thursday December 8, 2011 Status Member Last seen February 3, 2013 - Dec 28, 2011 at 09:00 AM
Related:
- Paste to all sheets except some with criteria
- Why can't i paste on instagram ✓ - Instagram Forum
- Sheets right to left - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- How to paste photo in resume - Guide
- Discord invisible name copy and paste ✓ - Internet & Social Networks Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 27, 2011 at 02:34 PM
Dec 27, 2011 at 02:34 PM
you need to put a IF statement or a select statement
For i = 1 To Sheets.Count sheetName = Sheets(i).Name Select Case sheetName Case Is = "Sheet1", "Sheet2", "Skip me" ' no action Case Else Sheets(i).Select Range("H400").Select ActiveSheet.Paste Range("A1").Select End Select Next