auto formatting

  1. S

    VBA Code to add thick outside border to cells containing specific text

    Hi Everyone, I'm trying to create a macro to edit/format pivot tables on one of my worksheets. This is the macro I have so far (there are 5 pivots): Sub EDIT_PIVOTS() ' ' EDIT_PIVOTS Macro ' ' Sheets("PIVOTS").Select Rows("1:30").Select Selection.EntireRow.Hidden = False...
  2. K

    Setting Printing Options in VBA

    Hi: I was looking for some help in setting the print orientation and paper size for an excel document in VBA. This document is being used by multiple people and despite asking them no to change the printing options, they sometimes do. I have a code to print the file from another excel file...

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