One way:

MsgBox ActiveSheet.Cells(3, 4).Value

In article ,
RajenRajput1 wrote:

Hello,

Imagine random numbers in cells between a1 and d5.

In cell a7 you could type a number , like 3
And in cell a8 you could type a number, like 4

What is the macro (or VB) code to return a value in b8 which is the random
number found in row 3, column 4, i.e. d3?

I know the excel formula, but not the VB.

Many thanks