how to move sheets from one workbook to another

  • Thread starter Thread starter vicky
  • Start date Start date
V

vicky

I need a vba code to MOVE the COPY of sheets from input.xls To
thisworkbook . "VBA code For Moving The Copy oF sheeets"
 
Sub test()
ActiveSheet.Copy after:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
End Sub

HTH. Best wishes Harald
 
hey thanks ... hey can you give a vba code to delete all the sheets
whose sheet name are not
coloured .......
 
Code like that is really dangerous.
Where is the coloring? Sheet names in colored spreadsheet cells, or colored
sheet tabs?
 
hey i got figure it out thru macro recording. thanks ....
For Each wksSheet In ThisWorkbook.Sheets
If wksSheet.Tab.ColorIndex = -4142 Then
wksSheet.Delete
End If
 

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

Excel Move or Copy Stopped Working? 0
Help with copying a sheet from One workbook to another workbook 1
Copy Worksheet 3
Adding values from two different worksheets from workbook 2
Unable to Delete Sheets or see Properties 3
Can Worksheet_Change be placed somewhere "universal"? 2
Copy ranges from several sheets to another one in a vertical position 1
copy past two existing sheets into 30 workbooks 4

Back
Top