Forum Discussion
Macro in Excel
Good afternoon, I just tried to write my first macro. I get a lot of spreadsheets with all text in upper case. I want it to be converted into first letter upper case and rest lower case. I managed t...
Hi
You recorded an "Absolute Macro" which repeats the same instructions to the same selection where you recorded it.
You need to Re-record the macro as a "RELATIVE" macro by highlighting the command "USE RELATIVE REFERENCE" in the Code group on the Left side of the Developer Tab of the Ribbon.
The macro recorder will record the steps RELATIVE to your starting point & will run the same steps Relative to the selected cell when you run it with a shortcut or any other method.
Hope that helps
Nabil Mourad