View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] kylancal@yahoo.com is offline
external usenet poster
 
Posts: 1
Default Is there a Way to Find the Cell Row and Column From my UDF

Basically i have a UDF in a module that is just

public function whatCellAMI() as string
WhatCellAMI = "Row: " & RowFunction & " Column: " & ColumnFunction

end function

Where RowFunction and ColumnFuncion are some way to find out the row
and column of the cell from which this function is being called. So if
it is Called in cell B4 it would say
"Row: 4 Column 2"

Does anyone know how to do this? THanks alot

Cal