Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Macro - changing value depending on the original value

Hello,
Can you please kindly help me to avoid lots of slavish work?
I have a column where there are - among others - also cells with the following values:
$$$to be sent
$$$to be sent2
$$$to be sent3
$$$to be sent4
$$$to be sent5

The active cell is just in this column (the cell is selected). I want a macro which would change these values (nothing else) in THIS column into $$$sent, preserving the eventual number indexes (meaning "$$$to be sent" into "$$$sent", "$$$to be sent2" into "$$$sent2" ....... ). (The cells not containing any of the above values should be left intact).
Please ask me for more explanation if convenient.
Very many thanks in advance!
Lib
Sign In or Register to comment.