Move selected column to end of dynamic range

[RedWing]

Hi

I have a dynamic range with a number of columns. I'm trying to set up a macro which sends a selected column to the end of the range, I've got everything up to the selection of the column sorted.

The procedure I have now cuts the selected column, and pastes it to a manual cell reference (e.g. cell F10) corresponding to the empty column at the end of the dynamic range. This leaves a gap where the column was cut.

What I need is for the columns in the dynamic range to automatically shift to fill the gap and without any need to make a manual cell reference for where to paste (i.e. it automatically shifts the other columns in the dynamic range to the left to fill in the empty column left by the cut, and pastes the selected column in the gap left by the shifting of the dynamic range, at the rightmost edge of the dynamic range)

EDIT* Accidentally posted in the wrong forum, could somebody please move this to the VBA section. Thanks.

Thanks everybody.

[RedWing]

Nm, fixed!