What version of Excel are you using? What you are referring to is called using "R1C1 reference style". In Excel2007 it is found under Excel Options -> Formulas and under the "Working with formulas" heading. I'm not sure where to find it in older versions of Excel (perhaps you can searc for R1C1)
Paul ________________________________ From: Balachander S <sba...@gmail.com> To: excel-macros@googlegroups.com Sent: Tue, February 16, 2010 11:05:47 AM Subject: $$Excel-Macros$$ Cell adddress changed automatically I have an excel shett for which i wrote macro in VBA the macro changes the cell address say : A! then It changes to B! The macro is not working becuase the cell address has changed to R(2),C(1) Any idea why the cell address has chanaged and how to change it back Baloo -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
