| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste special code | Excel Programming | |||
| Paste Special - Values code | Excel Programming | |||
| Simplify Code for Copy/Paste Special | Excel Programming | |||
| Code Assistance (Paste Special) | Excel Programming | |||
| Copy Paste Special Value using Code over Several Worksheets | Excel Programming | |||
Linear Mode
