-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
.sortfields.add2
-
H
Sorting macro
The problem here is I am poor at creating sorting macros, and use the recorder, and tried to implement a variable for the bottom row. This is an easy fix, right? I am getting error for this, "doesn't support this property or method". The first error is in Bold below. B_Row is defined just...- hitbid
- Thread
- .sortfields.add2 b_row sorting sorton=xlsortonvalues vba
- Replies: 4
- Forum: Excel Questions
-
VBA difference in Sort with: Add2 and Add (.SortFields.Add2 VS .SortFields.Add)
Hello, I sent a macro to another computer only to realize that it did not work because of a Sort issue in the code. With ActiveWorkbook.Worksheets("APP").Sort .SortFields.Clear .SortFields.Add2 Key:=Range("B2:B" & LastA), Order:=xlAscending .SortFields.Add2 Key:=Range("A2:A" &...- jbesclapez
- Thread
- .sortfields.add2 lasta macro order=xlascending working
- Replies: 4
- Forum: Excel Questions
-
Why in this macro there is telling Error104 Select methode of range class failed
Hi, I made this macro and get an error on this line Worksheets("Temp").Range("A1").SelectI run the macro from the sheet Q-Simple. I dont know why there is this error because if I select the sheet, than that means it is activated... so why this error. It is so basic... Please give me a clue...- jbesclapez
- Thread
- .sortfields.add2 lastrowa lastrowi order=xlascending xlpastevalues
- Replies: 7
- Forum: Excel Questions
