View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnZim JohnZim is offline
external usenet poster
 
Posts: 1
Default get row and column numbers

Hi,

I have a table of values in Excel and I used VLookUp to
get to a certain cell in the table. I am trying to write a
function that will sum up the value in the chosen cell (I
chose this cell using VLookUp) and the cell value directly
under the chosen cell.
I am assuming I need to first get the cell address of the
chosen cell and then use "Offset" to select the cell under
it but I do not know how to get the cell address of the
chosen cell. Can you help?