.header

  1. F

    Sorting code brings up 1004 Application-defined or Object Defined Error

    The following bit of code brings up the above 1004 error when it gets to .Apply, but for the life of me I can't work out why! Sub DataSort() Dim wsRes As Worksheet, wsPoi As Worksheet Set wsRes = ThisWorkbook.Sheets("Results") Set wsPoi = ThisWorkbook.Sheets("Title Points")...
  2. S

    Sort sheet regardless of sheet name

    Why does this not work? Sub Macro1() ' ' Macro1 Macro LR = Cells(Rows.Count, "A").End(xlUp).Row SN = ActiveSheet.Name Cells.Select ActiveWorkbook.Worksheets(SN).Sort.SortFields.clear ActiveWorkbook.Worksheets(SN).Sort.SortFields.Add Key:=Range("A1:A" & LR) _ ...
  3. P

    Macro adjustment

    Hello: I have read some ways to make this work but when I try them it doesn't. I want the macro below to be part of my file, then weekly I have to save the data into a new file and the tab where this data is located gets a new name. So I would like the macro to work on the active sheet, but it...

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