Yes..it works! Thanks
On Wed, May 6, 2009 at 6:30 PM, Fabio Lemos <flnle...@gmail.com> wrote:
>
> 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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
