hello friends ,
i have work book , it has around 10 sheets with lots of formulas in it , also with some hyperlinks
sheet1 : 05055
sheet2 : 05560
sheet3 : 06065
sheet4 : 06570
sheet5 : 07075
sheet6 : 07580
sheet7 : 08085
sheet8 : 08590
sheet9 : 09095
sheet10 : 09510
i want to copy first 5 worksheets to new work book with values and hyperlinks ....
then
i want to copy another remaining five to same new work book as values and hyperlinks again ....
purpose of doing so , is ......my excel gets hang when i use vba for entire work book at once ....
i was using below code ...for smaller workbooks previously ...
Sub CopyWSToNewWB()
Dim anySheet As Worksheet
ActiveWorkbook.Sheets.Copy
For Each anySheet In ActiveWorkbook.Worksheets
anySheet.UsedRange.Copy
anySheet.UsedRange.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
Next
End Sub
Bookmarks