Is there a Way to Find the Cell Row and Column From my UDF

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kylancal@yahoo.com - 30 Oct 2006 21:13 GMT

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

Reply to this Message

Bob Phillips - 30 Oct 2006 21:41 GMT

Public Function whatCellAMI() As String
With Application.ThisCell
whatCellAMI = "Row: " & .Row & " Column: " & .Column
End With
End Function

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Basically i have a UDF in a module that is just
>
[quoted text clipped - 11 lines]
>
> Cal

Reply to this Message