Paste special VB code.

N

Neil

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
 
E

Eduardo

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
 

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

Range(sheet2) = Range(sheet1) 11
Copy/Paste_Value problem. 5
same sheet copy/paste special 2
Sub to freeze all sheets & delete all comments 4
Paste Special Macro 4
Copy worksheet, trying to paste to new workbook error assistance. 1
CONCATENATE code 2
Referencing A Workbook 2

Top