View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hershmab Hershmab is offline
external usenet poster
 
Posts: 35
Default Create VBA function (UDF) in Excel 2003

How do I code a function
CellVal(rownum, colnum [, sheetname])
that will be the equivalent of the worksheet formula:
INDIRECT(ADDRESS(rownum, colnum [, sheetname]))
that will return the value of the specified single cell?

My knowledge of VBA is not good enough for me to find how to specify a
single-cell RANGE by its co-ordinates.