hi is there anyway to sort a range but the column to be sorted is based on
which cell is active ie if i have 3 cols - name, age, height i need to click
a button that sorts the col of whatever cell is currently selected. ideally i
would like to be able for the button to sort the other way ie descending if
clicked again. To complicate things the range is dynamic

Hope you guys can help

Thanks
kevin