View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mcambrose mcambrose is offline
external usenet poster
 
Posts: 27
Default Worksheet function to retrieve cell value based on row an col numb

I want to be able to reference cells by the row number an column number
rather than using the column letter. I am contatenating strings to make a
formula where I increment the column. I have tried r1c1 notation and this
doesn't seem to work for me. Is there a function like +cellvalue(1,1) that
will return the value in a1?