Dear Vivek,
Without using VBA
Please try through below function..
=get.cell(63,Indirect(RC[-1],))
See attached sheet for more clarity.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/* http://excelmacroworld.blogspot.com/
Dear Group members,
I want to use sumif function to sum a particular range based on the cell
colour. Is it possible. I am enclosing herewith a sample file.
Please help..
Thanks Regards...
CA Vivek Jain, FCA, DISA (ICAI)
Vivek Shantilal Jain Co.
Chartered Accountants
3010 Ram Kumar