format cells copying

  1. C

    Copy, PAste Special, Format only HELP

    I'm a bit brain dead tonight and cant make this work. Simply trying to copy the formatting of the range from N4:N5 to the entire columns of O and T, both starting in row 4. Row length will be variable from sheet to sheet. Here is what I have. Sub reformatStripes()' ' reformatStripes Macro '...
    • chefdt
    • Thread
    • copy format cells copying paste special issues
    • Replies: 5
    • Forum: Excel Questions
  2. L

    Adding or copying formatting of rows in protected worksheet

    I have a worksheet that has formulas in row 10. All the formulas except the first one are based on a rolling calendar year (for sick leave), and the first formula is based on a calendar year. One column also has a formula in each cell, but I left it unprotected and used data validation to let...
  3. D

    Excel 2007 Button to add more rows to table

    Hello there, This is my 1st time trying to code in VBA. I have a table (with formatting) with 8 columns on sheet 1 of my workbook in Excel 2007. I have created a button that when clicked it adds 37 rows to my table (just enough to add another page for printing). Below is my code Sub...
    • duffers123
    • Thread
    • duplicate worksheet format cells copying insert row remove columns
    • Replies: 7
    • Forum: Excel Questions
  4. L

    Copying Formatted Value rather than True Value

    I am sure I am about to ask yet another noob question, but I can't seem to figure out an easy solution. Is there a way to copy and paste the values as displayed by Format Cell. I have a lot of data in the billions that I have formatted to decimals using a custom format of "$0.00,,," For...
  5. W

    Mirror the format of another cell automatically

    Hi, Does anyone know if it is possible to mirror the format of another cell without using the format painter? e.g. Cell A1 is BLUE and BOLD, Cell A2 is Red and non-Bold, Cell A3 is green and italics, Cell A4 is Yellow and undelined. I want to have cell B1 formatted the same as A1 if it contains...

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
Back
Top