Set active cell in working macro

[abjac]

HI Maybe some could help me with this.
I have below working macro. I have to select example column A and then i can run it. But what ever i have tried to do i cant set this range in the macro. I have to select it.
Either it dont work or it come with a out of stock error.
So if i can example have an inputbox asking for the range it will be perfect. Or at least so the active cell is set to the cells in column A example.

Please have a look

Thanks

Sincerely

Abjac

Please Login or Register  to view this content.

[patel45]

explain better your goal, attach a sample file

[Andrew-R]

Something like this, maybe:

Please Login or Register  to view this content.

I've cleaned up a couple of bits of code in there, but there's more that can be done.

For example, if you want to replace all of the commas in S with periods you don't need to loop through, you can just have:

Please Login or Register  to view this content.

[abjac]

HI Andrew. Thanks allot its working really perfect. Just what i needed.
Have a nice day
Sincerely
Abjac

Patel 45 Thanks to you too i am sure you could have made this, but this is working perfect so no need to work more on it. But thanks allot to you too