I got rid of the last . value and it works.

Thanks.

--
Orlando Vazquez


"Dave Peterson" wrote:

Application.goto range(range("a1").value).value



ORLANDO VAZQUEZ wrote:

Thank you!
I have a related question please if you have time...

====
In a macro such as ....Application.Goto Reference:="abc"
where "abc" equals the results of the formula in cell a1

I want to goto location specified by the formula in cell A1.

For example if cell A1 formula result = equity1
When I run this macro I want to goto range "equity1"

Please let me know.

Thank you.

Orlando

I want to goto the range named "equity1"

--
Orlando Vazquez

"Dave Peterson" wrote:

The sheetnames are in A1?

=VLOOKUP(A2,Indirect("'"&a1&"'!B10:Q561"),3,FALSE)



ORLANDO VAZQUEZ wrote:

Hi,

How can I re-word the vlookup in A3 below so that when cell A1 value changes
then the TABLE_ARRAY in A3 will adjust to the new value, i.e., Equity2,
Fixed1, Alternative4, etc..

A B C

1 Equity1 [this is a formula referring to the tab name and subject to
change]

2 11/30/2008

3 =VLOOKUP(A2,Equity1!B10:Q561,3,FALSE)

Thank you.

--
Orlando Vazquez

--

Dave Peterson


--

Dave Peterson