Hi Melissadianna,
If you record a macro and it does Range("A1").Select type of commands, it is working on the active worksheet. If you run that macro from a different sheet (the one it wasn't meant to run on) it can really mess things up.

In my code above I was very careful to specify which worksheet was the one being used.

My concern is that if you run a macro from a key combination like Ctrl-B you need to make sure you are on the correct sheet before letting the macro run.

This is my concern for making more macros using the recorder and simply calling them.

I hope that helps.