Help amending a macro needed

I have a macro that inserts a bullet before every line of text in a cell.

You just highlight a cell and run the macro and it works.

I would like to amend the macro so I can run it for all cells in a column.

So for example A1 to A500.

Here is the macro.

Please Login or Register  to view this content.

Thanks for any help.