Cannot Sort Range VBA - "Unable to get sort property of range class"

**jkj115** · 02-13-2015, 04:00 PM

I am trying to sort a range in VBA and have tried numerous ways of identifying the range without success. I can't figure out why I get the run-time error on the sortfields.clear line (also when I inactivate this line I get the same error on the next line)

Please Login or Register  to view this content.

**walruseggman** · 02-13-2015, 04:30 PM

Though I have limited knowledge on the subject, i think using .SortFields requires a Worksheet or ListObject object. I don't think you can use a range. Changing the range to a worksheet allows that line to work for me.

**jkj115** · 02-13-2015, 04:46 PM

ah that was it. thx!

**StuCram** · 02-13-2015, 04:51 PM

You should check that the last data column to the right does not have all empty cells below the top cell; if so, the selected area goes all the way to row 1048576. That large range may be causing the runtime error for SORT.

Just a thought.
-Stu