Hi
1. if you enter the column as letter 8e.g. 'B') try:
=INDIRECT(E10&E11)

2. Personal.xls is a workbook which is opened automatically then you start
Excel (but hidden). It is used to store common macros which could be
accessed from all workbooks. See:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

3. Also see the above link for getting started with macros

--
Regards
Frank Kabel
Frankfurt, Germany
"mango" schrieb im Newsbeitrag
...
dear all,

1) i got the help from this forum of the intersect. may i know if i want
user to input the column and row in respective cell then the result will
appear in another cell.
at the cell if i just put = column header row header (tools, option,
calculation - check accept label) i manage to get the result. now if i
have
something like below, the function in result cell what should i put?

assuming the input column cell is E10, input row cell is E11, result cell
is
E12
input column ___
input row ___
result ___

2) may i know what is the use of personal.xls? what is personal.xls?
3) what is the use and what is addins?

thanks alot