Thanks Sam , it is useful for me also.
prince
On Monday, August 6, 2012 10:08:09 PM UTC+5:30, Sam Mathai Chacko wrote:
>
> =HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1)
>
> Regards
>
> Sam Mathai Chacko
>
> On Mon, Aug 6, 2012 at 9:41 PM, ashish koul
> > wrote:
>
>> =HYPERLINK("#'"&SUBSTITU
Dear Kantilal, Sam & Ashish
All your options work and are helpful. Appreciate your help and thanks a
lot (Couldn't respond earlier as I was away)
Thanks
Ashish Pradhan
On 07-08-2012 10:56, Kantilal Badale wrote:
Try CTRL+[ ] from formula cell
CA Kantilal Badale
E-Hall, First Floor,
B. J. M
r(.Formula, "!") + 1, 256)
Application.Goto reference:=Sheets(ms).Range(mc)
End With
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Kantilal Badale
Sent: Tuesday, August 07, 2012 12:26 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Exce
Try CTRL+[ ] from formula cell
CA Kantilal Badale
E-Hall, First Floor,
B. J. Market,
Jalgaon.(Maharashtra)
9822250393
On Mon, Aug 6, 2012 at 10:08 PM, Sam Mathai Chacko wrote:
> =HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1)
>
> Regards
>
> Sam Mathai Chacko
>
>
> On Mon, Aug 6, 2012 at
=HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1)
Regards
Sam Mathai Chacko
On Mon, Aug 6, 2012 at 9:41 PM, ashish koul wrote:
> =HYPERLINK("#'"&SUBSTITUTE(CELL("address",Sheet2!A3),"!","'!"),Sheet2!A3)
>
>
>
>
> On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan wrote:
>
>>
>> Hello
>>
>> I hav
=HYPERLINK("#'"&SUBSTITUTE(CELL("address",Sheet2!A3),"!","'!"),Sheet2!A3)
On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan wrote:
>
> Hello
>
> I have many cells with formulae in them in Sheet "Main"
>
> For Example:
>
> ='Staff Bonus'!E67
>
> Is there a simpler way to go to the Sheet "Staff Bon
Hello
I have many cells with formulae in them in Sheet "Main"
For Example:
='Staff Bonus'!E67
Is there a simpler way to go to the Sheet "Staff Bonus" and cell "E67"
from the "Main" sheet which contains this formulae?
I think I was able to do this much earlier, but either I am mistaken or
