.apply

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")...

Hi All. I have a sheet with a number of Tables in it that I would like to sort on a regular basis. Currently I have the following code which works, but I'm curious to know if there is a easier way with looping to sort all the tables in the sheet at once. Any suggestions? Sub Sort_Lists()...

I'm getting error 1004 when I try to apply the following code to sort a range, I've tried several different ways of defining the range (which I need to do using variables) but it keeps failing on the .Apply line of code: Sheets(SheetName).Select SheetRecordCount =...

I have a button that's supposed to alphabetically sort a table by the first column so the end user won't have problems finding employees even when the worksheet is protected. Unfortunately the code that I have and that worked fine when I first tried it won't stop returning a run time 1004...

Hi everyone. I've got a button that's supposed to sort a table when clicked but it's giving me a run time 1004 error. Any idea why? The .Apply line gets highlighted. It happens wheter the sheet is protected or not. <code class="s90z9tc-7 klSgyG" style="margin: 0px 2px; padding: 0px; border...

I started the macro below which sorts rows 1-3 individually from smallest to largest. It sorts B1:E1,then B2:E2, and then B3:E3. The code is the same for each row of the worksheet with the exception of three minor changes in the code due to moving to the next row. I need this macro to...