paste values and formats

  1. R

    rCopy...paste values

    I am trying to copy row 2 from a number of files in to a list I have used this code, which pastes "formula". can it be changed to "paste, then paste values"? Thanks in advance [Code] With Workbooks.Open(sFolder & sFile) Set rCopy = .Sheets("TF ROC").Rows("2:2")...
  2. T

    Simple Copy / Paste Formats & Values

    I have scoured the internet, and can't find anything that I can decipher that is even close to what I need, although all of it seems to work for others. This is what I have: Sub App_Mig_Status() Workbooks("Recieving.xlsm").Worksheets("Recieving_Data").Range("A2:AS2001").Value =...
  3. M

    Retain Pivot Table Formatting

    I've seen many posts about retaining the pivot table formatting when pasting values to unlink it from the source. The paste special values does not work. I've tried using the clipboard to paste and it worked one time. In the same workbook attempting to copy and paste the values and formatting...
  4. J

    VBA to Convert Selected Pages to Values Only in separate workbook

    Good morning! I have this amazing bit of VBA that allows me to select pages and print in a proper order & aligns the page numbers. I want to keep this, but add an option to convert those pages to values & formats only instance of excel. Either by creating a copy of the pages into a new...
  5. L

    Copy / Paste Values & Formatting of Worksheet with Pivot Table

    Hi there. I generate reports for a client each day. They have gone through many iterations, the most recent of which utilizes a PivotTable. The PivotTable exists on its own worksheet (Tab). When my report is complete, I need to copy/paste values and formatting of the entire tab to a new...
  6. D

    Simple Paste Values and Formats Macro

    In Excel 03 a simple command for pasting values and formats was included. In Exel 07 is its missing. Only a paste values button is available on the tool bar or custom list. So I tried to create a simple macro to paste formats and values using paste special after selecting my range. I...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top