Hi dear all,
For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1 has. Now B1 has value"A", and C1 has value "1", I want D1 has the formula "=A1" It doesn't work when I type "=B1&C1" in D1... Can anyone gives some shine on it? I know how to do it in VBA..quite easy: range("D1").value =range (range("B1")&range("c1")).value. But i do not know how to do it on spreadsheet. Thanks A B C D -------------------------------------------------- 10 A 1 =A1 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---