Get cell address from two cells in other sheet

[kmlprtsngh]

Hi all,
I have two cell one containing row number and other column number of a cell in sheet2.
Can anyone suggest a way of how to access that cell in sheet2 from information in sheet1 using excel vba.

[pike]

Hi kmlprtsngh
Hard to say but you could use a User define function UDF

Please Login or Register  to view this content.