field=1

  1. T

    Excel Macro to filter/paste data

    Hello, I have searched and found examples closely related to what I am trying to do, but still need help. I have recorded a macro of the desired process, shown below. AutoFilter Field:=1, Criteria1: will vary based on what the user populates in cell Sheet1!B1 AutoFilter Field:=1, Criteria1...
  2. J

    VBA Code Efficiency

    Hello, Can I make the following code run quicker? Other than run it on the hard drive rather than the OneDrive? Many thanks. Sub Clean_Data() Dim myValue As Variant Dim myValue2 As Variant Application.ScreenUpdating = False Application.DisplayAlerts = False Dim FP As String, FN As String...
  3. P

    Cdoe Excluding specific Tabs

    Hello, I have written code to copy down a formula in one cell into all the other cells in a column. I need to repeat this for several tabs in my workbook, however I want to exclude certain tabs from this task as they do not have the same information in their cells. How do I write this to...

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