Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a Way to Find the Cell Row and Column From my UDF
Public Function whatCellAMI() As String
With Application.ThisCell whatCellAMI = "Row: " & .Row & " Column: " & .Column End With End Function -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message ups.com... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|