How to get a macro to run on all selected cells in a sheet?

Hi,

I am just starting to learn macros and I wrote one that appends a "-p" to a cell. How can I get this to work on all selected cells?
can someone tell me how I can run the same macro on all selected cells in a column??

Please Login or Register  to view this content.

Cheers,

Thanks

How about:

Please Login or Register  to view this content.

Works like a charm

Hi Kyle,

I just noticed. I i make a selection in a filtered column then it applies the -p to all the values that are not in the filter as well.. how can we go about doing this?