http://msdn2.microsoft.com/en-us/office/aa905357.aspx

http://www.excel-vba.com/excel-vba-contents.htm

and others you can find.

>That works well Sergey, thank you.
>
>I need to learn VBA, there is a lot of value there. I think the Excel help will be fine for filling the details, but it is not useful enough because I need to understand the "big picure" first. Do you know af any resource where I can go to for that?
>
>I appreciate your help.
>
>Alex
>
>
>
>>Replace harcoded column # with & CELL("row")
>>

>>=INDIRECT("'" & INDIRECT(LEFT(ADDRESS(1, CELL("col"),4,TRUE),1) & "7") & "'!D" & CELL("row") )
>>

>>
>>>That is excellent, thank you. If it is not optimal it is plenty good enough.
>>>
>>>I had made one mistake in the description of the problem, though (sorry). I should have said:
>>>
>>>If the formula is in cell S10, the formula should be =INDIRECT("'" & S7 & "'!D10"). (The name of the worksheet is always in row 7 of the same column where the formula is, and the row from where the data is extracted should be the same row where the formula resides).
>>>