export as values

  1. P

    Macro button which export range of worksheet to a new file and save as xls or pdf

    Hi, there, Can anyone help me to figure out the macro commands which: 1. Copy the specific range of sheet into a new workbook; 2. Copied workbook will contain the cell values and format only not the strings or formulas. 3. "Save as", so the user can choose the directory and the name of the...
    • PitMax
    • Thread
    • export as pdf export as values macro button
    • Replies: 4
    • Forum: Excel Questions
  2. A

    Export tabs as values issue

    Hi, I am looking to edit the below code so it works properly. Currently it exports all of the tabs in the named range MLS. All of the tabs in this range are heavily formulated and for some reason when it exports them it leaves out any cells that have formulas in it. Also I was wondering what...

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