If the current cell is known (even if you do not know where that is) and you
want to know the value of a cell 2 columns over and 5 rows down then

activecell.offset(0,0).select

msgbox activecell.offset(5,2) .value,vbinformation, "Offset Manager"


- - Mark


"Ken G." wrote:

What is the correct vba syntax to use to make a particular cell the active
cell when the row number and column number are known?