$$Excel-Macros$$ Re: How to retrieve the address of a cell used in a formula

2009-07-25 Thread Dilip Pandey
Hi For the benefit of the Group, can you attach a sample file containing the dummy scenario. Thanks DILipandey On 7/25/09, Telenochek wrote: > > Hello everyone, > > I have a worksheet that calculates system performance on Sheet1 based > on electronic components, whose data is located in other

$$Excel-Macros$$ Re: How to retrieve the address of a cell used in a formula

2009-07-25 Thread Daniel
.com > Subject: $$Excel-Macros$$ Re: How to retrieve the address of a cell used in a > formula > > > Hello. > To obtain Amplifiers!E2 : > =OFFSET(INDIRECT(A1);1;0) > Amplifiers!E3 : > =OFFSET(INDIRECT(A1);2;0) > Etc. > Daniel > > > -Origina

$$Excel-Macros$$ Re: How to retrieve the address of a cell used in a formula

2009-07-25 Thread Manish Purohit
Could you attaché the excel file. Manish Purohit Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Telenochek Sent: 25 July 2009 0

$$Excel-Macros$$ Re: How to retrieve the address of a cell used in a formula

2009-07-25 Thread Daniel
Hello. To obtain Amplifiers!E2 : =OFFSET(INDIRECT(A1);1;0) Amplifiers!E3 : =OFFSET(INDIRECT(A1);2;0) Etc. Daniel > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel- > mac...@googlegroups.com] On Behalf Of Telenochek > Sent: vendredi 24 juillet 2009 21:52 > To: MS EXC

$$Excel-Macros$$ Re: How to retrieve the address of a cell used in a formula

2009-07-24 Thread vivek agrawal
Hi Can u please attach a sample sheet... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 1:22 AM, Telenochek wrote: > > Hello everyone, > > I have a worksheet that calculates system performance on Sheet1 b