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 [email protected]
If you find any spam message in the group, please send an email to:
Ayush Jain @ [email protected] or
Ashish Jain @ [email protected]
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
