help needed vba

  1. T

    VBA doesn't refresh Pivot Table

    Hi VBA Experts,' I have this simple VBA to refresh a single Pivot Table in a file, but it doesn't work. This is a small part of many steps in my process. The PVT Data doesn't refresh and thus, this throws out the other steps. Sub Workbook_RefreshAll() Sheets("PVT").Activate...
  2. T

    VBA to Highlight #N/A in dynamic range dataset

    Hi VBA Experts. I have looked everywhere but can't seem to find a VBA Sub to find and highlight #N/A in a dataset if any exist. The dataset is hardcoded data formatted as general. I even try to record a macro to do this, but the recorder doesn't record the "Find & Replace" box activities. Any...
  3. T

    Rename all files in a folder based on a cell value

    Hi experts, Can someone help me with a VBA Code that will loop through a predefined folder and rename all the files in a folder based on cell B2? Will need to incorporate the CLEAN Function because of the spaces in cell B2. I looked online for VBA scripts to do this task, but couldn't find one...

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