Hi I am sorry for not using the RULES for the codes. I hereby edit my post.
Thanks
Hello
I am tired of reading the cell reference using FormulaR1C1 method in macros. like
Is there any way it can show the normal cell reference![]()
Range("L4").Select ActiveCell.FormulaR1C1 = "=RC[-4]-RC[-2]"
like
Thank u![]()
" =J-H" instead of "=RC[-4]-RC[-2]".
Toms
Bookmarks