Hi all,
Why does this not work unless im actually on the sheet? This is part of a Userform and as long as i have the 'Runners' sheet open it works fine, but if i have another, it throws an error
Sheets("Runners").Range("A:AA").Sort key1:=Range("D1"), order1:=xlAscending, Header:=xlYes
Cheers