Paste special VB code.
I have a work book consisting of several work sheets, all with either links
to other work sheets, or formulas. The main sheet has links & formulas and I would like to copy the contents of the sheet & paste special into a new sheet within the same workbook I want to use special to copy 'values', 'formatting' and 'column width', can I do this using VB code? Thanks |
Paste special VB code.
Hi
CopyRng.Copy With Sheets("BackLog_Summary").Cells(Last + 1, "A") .PasteSpecial xlPasteValues .PasteSpecial xlPasteFormats Application.CutCopyMode = False End With Change names to fit your needs "Neil" wrote: I have a work book consisting of several work sheets, all with either links to other work sheets, or formulas. The main sheet has links & formulas and I would like to copy the contents of the sheet & paste special into a new sheet within the same workbook I want to use special to copy 'values', 'formatting' and 'column width', can I do this using VB code? Thanks |
All times are GMT +1. The time now is 12:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com