I assume that you have pasted the code into the vb editor, either in a sheet module or a code module ? Perhaps better in a code module.

Then with your column range selected - run the macro by whatever means you wish or have set up, e.g. shortcut , button, Macro Run, direct from the vb editor ...