Advertisement
Guest User

Untitled

a guest
Aug 6th, 2018
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub cSheets()
  2.  
  3. Dim cSheet As Word.Document
  4.  
  5. Set cSheet = Word.Application.Documents.Add
  6.  
  7. ThisWorkbook.Worksheets(1).UsedRange.SpecialCells(xlCellTypeVisible).Select
  8.  
  9. With Selection
  10.     .Range("F1, G1, J1, M1").EntireColumn.Copy
  11. End With
  12.  
  13. cSheet.Paragraphs(1).Range.PasteSpecial (Paste)
  14.  
  15. Word.Application.Visible = True
  16. Word.Application.Activate
  17.  
  18.    
  19.  
  20. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement