The "Range" method of the "Global" object failed
I took the Excel document we used at work and modified it for a separate development task.
I was told that as long as column E stays on the date, the "Show Only Most Recent Releases" macro should still work.
However, I am getting the above runtime error and when I select debug I am not sure what to change to fix the above 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 for the column headings as well as data validation ranges for the columns that should not be included in the macro.
Thank.
source to share
I am assuming you changed the column heading in column E. Before it looks like "Release Date" with a line break between the release and the date.
If you changed the column heading, you either need to change it or update the macro to use the new name. The column name must appear between the parentheses after "Table1".
source to share