Using cell Adress in formula

peak

New Member
Joined
Mar 15, 2002
Messages
3
Here is an example of what I am trying to do.

I am calling a cell location in a cell. So say in A1 there is the value $B$5.

Now I want to use this cell location ($B$5) in a formula in say cell A3.

Any idea how this could be accomplished, (hope it is spelled out clearly!)?

Thanks guys
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Create a function in a module like below.

Function TextRange(myrange As Range)
TextRange = Range(myrange).Value
End Function

And call it in A3 like this ;

=TextRange(A1)

We dont need excel functions all the time. We can create ours for our specific needs.

By the way i dont know if this could be with an internal function.


regards
suat
PS: dont forget to visit TheWordExpert for VBA help and also other office applications and subscribing for monthly newsletter.
This message was edited by smozgur on 2002-03-16 17:05
 
Upvote 0
Thanks smozgur.

It is coming back with #name?

Is there anything else I have to do to activate the function? I have placed what you advised in a module.

Thanks again.
 
Upvote 0
Yeah sure did.

The function appears under Insert>function>userdefined
but still returns #name?
 
Upvote 0
Peak,

easier, Excel had an internal function :)

=INDIRECT(A1)

if A1='B5' then formula return B5 cell value.

i told you that i didnot know if it exists :)

suat
 
Upvote 0

Forum statistics

Threads
1,213,550
Messages
6,114,265
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top