You will need to use the indirect formula, which converts an addres to
a reference
=indirect(b1 &c1)
Regards!
Fabio L. Lemos
cel.: 8122-1206
Em 06/05/2009, às 11:34, Yu <vincent2...@gmail.com> escreveu:
>
>
> 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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
