Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Copy and PasteSpecial Values into a new workbook
Thanks for this, I'm just copying all the sheets to one single workbook. When i try to run this though, I get a Run-time error '438' message with the line: Sheets(i).Cells.Copy highlighted on the debug G.- gsx600f
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copy and PasteSpecial Values into a new workbook
I currently have an Excel macro that copies a whole sheet from a workbook into a new workbook, but pastes the values only, and then formats them to fit, ready for e-mailing: Worksheets("Sheet1").Copy z = ActiveSheet.Name ActiveSheet.Range("A1:K250").Copy...- gsx600f
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
