CODEWITHSUNDEEP
excelvba
Leah Ford
Leah Ford

Reputation: 33

Method 'Range" of object'_Global" failed

I have taken a Excel document we use at work and modified it for a separate task that has developed.

I was told that as long as column E remained a date then the "Show Only Most Recent Issuance" macro should still run.

However I am receiving the above Run Time Error and when I select debug I am unsure what to change in order to fix said error.

Any help would be greatly appreciated.

ActiveSheet.ListObjects("Table1").Sort. _
    SortFields.Add Key:=Range("Table1[Issuance" & Chr(10) & "Date]"), SortOn:=xlSortOnValues _
    , Order:=xlDescending, DataOption:=xlSortNormal

The changes I made were only to the column titles and also to the data validation ranges for columns that should not be included in the macro.

Thanks.

Upvotes: 3

Views: 350

Answers (1)

Justin C
Justin C

Reputation: 1924

I'm guessing you changed the column title in column E. Before it looks like it was "Issuance Date" with a line break in-between Issuance and Date.

If you did change that column title you either need to change it back or update the macro to use the new name. The column name should go between the brackets, after "Table1".

Upvotes: 3

Related Questions