To retrive data from datatable which is in 3rd row and 4th column

'in Action1 sheet change the names of A,B,C,D columns with A,B,C,D respectively.
'And type the values in D column

datatable.SetCurrentRow(3)
answer=datatable(4,2)'.Value(4,2) '4th column in 2nd Sheet
msgbox answer
'Run the program

'-------------------------------------
'To retrive value from 3rd row 4th column from external excel sheet

datatable.Importsheet "c:/1.xls",1,1
datatable.SetCurrentRow(3)
val=datatable.Value(4,1)'4th column 1st sheet
msgbox "The Value is "&val