paste formatting

  1. W

    VBA Paste Pivot Table Data to multiple Worksheets Keeping Pivot Table Format

    I have created some VBA code to copy multiple Pivot Tables on different tabs and Paste them in a new workbook in a temp file location to be emailed from a list in the source workbook. Everything works well except when I paste the pivot tables it only paste the data and not the format. I have...
  2. 9

    Posting Values and Formats with VBA

    I need to take the formats from one sheet and copy to another sheet and the values of the original sheet and post to a separate sheet. All my info is on sheet 2. I need to post the formats to Sheet 1 and the values to Sheet 3. This is what I have but it doesn't work...
  3. G

    Paste Formatting is pasting in Hidden/Filtered Cells

    Hello, I've started a new job and the Excel settings here are different than the computer I used to have. Before, I could filter a list and copy/paste formatting into all the cells in the filtered list. When I cleared the filter, normally the cells that were just filtered are the only ones that...
  4. S

    Copy and Insert Rows - Use Dynamic Range and Paste to First Blank

    Hello, Am currently an intern and a VBA newbie. Looking to write a code that inserts rows from one master template sheet and enters them into another interview sheet. The template may change and this process needs to be repeated a certain number of times. (this number is set of certain cells...
  5. X

    Customize "paste" operation to paste only Values (without format from copied data)

    Hello, For one my workbooks, I have a requirement where, I want to modify the regular "paste" operation in such a way that it acts as "Paste Special->Values". The context is that - In the worksheets, I have several conditional formats being used which are different in different columns, and I...
  6. D

    Problem with paste formats

    Hi Im using a modell where I need to save around 40 sheets to the location of the workbook. The sheets should be saved as values and that works fine but I would also like to transfer the formats, and I cant get this to work. I pieced together a code, like I said the paste special formats dont...
  7. M

    Prevent paste action in a Worksheet

    Hi <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I need to prevent a paste action in 3 columns in a worksheet as it removes formatting and Data Validation and the drop down values get lost. <o:p></o:p> <o:p></o:p> To explain : I have three columns...

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