Hi,

Is it possible to use the Sort method in Excel VBA to sort values contained
in a single row? If so, how? I tried this by declaring a range (which
represents cells in a single row) and the applying the sort method to this
range and this does not work.

I know this works for sorting columns, but I want to sort left to right
across a row. Any assistance is appreciated.