When a formula is typed in a cell in Excel the formula is automatically capitalized. i.e. "=average(A1:A25)" becomes "=AVERAGE(A1:A25)". Is there a way to automatically change the case of a homemade formula like Excel does? i.e. "=myhomemadeformula(A1)" becomes "=MYHOMEMADEFORMULA(A1)". Things I've tried like below haven't worked.
Code:
ActiveCell.Formula=UCase(ActiveCell.Formula)