Hi All,
I am trying to write a macro to sort on two separate columns based on the header in the column. I've tried a few different things and keep getting error 1004 method range of object _global failed. I assume it has something to do with the way I'm setting range variables but cant seem to figure it out. If someone could show me the right syntax for setting two range variables; one for the column with header "FY" and the other for the column with header "Location" that would be much appreciated. I am then trying to sort ascending first on FY and second on Installation.
Thank you for your help.
Bookmarks