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

CONCATENATE code 2
Copy/Paste_Value problem. 5
Formatting and copy or copy and formatting ?? 2
Converting URLs in comments to Markdown-formatted links 2
filter function 0
Drawn Objects Q 2
Copy columns and paste with blank column between 5
Copy adjacent Sheet and name from a list 42

Top