Re: $$Excel-Macros$$ Find out the value of the cell based on row and column

2017-07-25 Thread Vijayendra Rao
Hi Paul, Thanks for your support. I tried Indirect function and it did not work. I have used macros which is working perfect. Attached is updated file. Regards, Vijayendra 2017-07-21 21:12 GMT+05:30 Paul Schreiner : > use: > =INDIRECT(E3) > *Paul* > - >

Re: $$Excel-Macros$$ Find out the value of the cell based on row and column

2017-07-21 Thread Paul Schreiner
use:=INDIRECT(E3) Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley --

$$Excel-Macros$$ Find out the value of the cell based on row and column

2017-07-21 Thread Vijayendra Rao
Hi Experts, I have cell value called $A$5 (Will change based on selection of active cell) and need to get the suitable function which should reflect the value of the $A$5 (will change). Attached is the excel file, request you to help on the same. Regards, Vijayendra -- Are you =EXP(E:RT) or =