Macro that can change a line of code in another macro

I would perhaps come at this from a slightly different angle. Rather than have one macro 'physically' change another you can use a 'switch'.

Please Login or Register  to view this content.

The idea is a Boolean variable is set to True only when Sub Two is run so your line of code will only run if Sub Two is run BEFORE Sub One.

Is that of any help?

BSB

depending on who is using the workbook depends on which is needed...sometimes I need it cleared sometimes not. That is why I would like to automate it rather than having to do it myself every time.....I am not always available.

As you can see the line I would like to change from time to time is at the bottom of this code.

how would I incorporate the switch with the code to work??

Please Login or Register  to view this content.

I presume you have a button or similar to run the code above (without that line of code)?

Will you have a separate button to run it WITH that line of code or another method?

BSB

I have one button that runs the above code. I manually update it depending on whether I want the line commented or uncomment on the line.

That is why I was thinking of a macro that could change that particular line just by activating that separate macro and still be able to use the existing macro to run the overall code.

And how do you plan on activating that separate macro? A separate button?

If yes then you'll have a macro run by that second button:

Please Login or Register  to view this content.

Then change this line in your existing macro:

Please Login or Register  to view this content.

To this

Please Login or Register  to view this content.

You still use your existing macro, but with that slight change.

BSB

Why not simply have a message box asking if you want to clear the cells?

Please Login or Register  to view this content.