I know how to pass simple ranges to a custom function (ranges in the same sheet as the function usage). How can I pass the address of a cell in a different sheet to that function. For example
myfunction(sheetname, rownum,colnum, cells)
I only need to pass the address of one cell of the other sheet.