I have two simple macro problems -
First, when I record a macro, the small box that used to appear in the middle of the screen allowing me to stop recoding doesn't appear anymore. How can I get it to appear?
Second, say I want to record a simple macro that selects the column containing the active cell and format the column to bold. When recording the macro, the active cell happens to be A1. When I run the macro,it selects column A rather that the column containing the active cell. I think it has something to do with relative versus absolute references. Please help.
First, when I record a macro, the small box that used to appear in the middle of the screen allowing me to stop recoding doesn't appear anymore. How can I get it to appear?
Second, say I want to record a simple macro that selects the column containing the active cell and format the column to bold. When recording the macro, the active cell happens to be A1. When I run the macro,it selects column A rather that the column containing the active cell. I think it has something to do with relative versus absolute references. Please help.