How to make Sort Macro work referencing Table

[eybjerke]

Hi,
What's wrong with my code?

Please Login or Register  to view this content.

[xlnitwit]

Hi,

Your Sort routine calls SortRows- not SortRows1- which is not posted, so hard to comment on.

[eybjerke]

Hi,

Your Sort routine calls SortRows- not SortRows1- which is not posted, so hard to comment on.

Just a typo in the thread. It's not the problem.

[xlnitwit]

Then perhaps you might tell us what is the problem. What happens with your code?

[eybjerke]

Then perhaps you might tell us what is the problem. What happens with your code?

Runtime Error '424': Object Required

Fails at this line:
If Not Intersect(Target, Range("TAB[[#All],[In Service Date]]")) Is Nothing Then

It works with Range (below), but fails when trying to reference Table.

Please Login or Register  to view this content.

[xlnitwit]

What is Target supposed to be in that code? It isn't declared or set anywhere.