Cell References in Excel Macro

Hi, I want to write a Macro in excel then it can find whatever in C2 and replace it with C1 in the whole worksheet.

Please could you advice what to write it the Ctrl-H (find and replace menu) in the find and replace sections then it can go to the following:

D2=>D1

E2=>El

etc…

Thanks,

Masoud

By: Masoud

Leave a Reply

Your email address will not be published. Required fields are marked *