Allow user to define range for Text to Column

[punter]

Hello everyone,

I am looking to build a simple macro performs a text to column function. See below:

It works well enough but I want to be able to highlight any range I want and then use the macro. For example with a paste special macro I can just use "Selection.Copy" and that macro will perform the function on any range that I highlight. How can I do the same with the macro above?

Thanks

Eddie