current cell in user-defined function

  • Thread starter Thread starter Julio Kuplinsky
  • Start date Start date
J

Julio Kuplinsky

Is the current cell (not the active cell) available in a
user defined function? For instance, can I say

public function foo()

' Give me the row of the worksheet cell where this
' function is entered

end function

Thanks
 
Julio,

You can't get the cell details (AFAIK), but you could pass it to the
function, for example

Function foo(rng As Range)
If rng.Count = 1 Then
foo = rng.Row
End If
End Function

and call it like so
=foo(A24)

By making it a relative reference, it will update as you copy to other
cells.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi,

Use Application.Caller property.

Function CellRow()
CellAddress = Application.Caller.Row
End Function

when you enter that function in a cell it gives the row number of cell where the function is entered.


--
Regards

Haldun Alay

To e-mail me, please replace AT and DOT in my e-mail address with the original signs.



"Julio Kuplinsky" <[email protected]>, iletide sunu yazdi Is the current cell (not the active cell) available in a
user defined function? For instance, can I say

public function foo()

' Give me the row of the worksheet cell where this
' function is entered

end function

Thanks
 
Oooppppss!
function will be

Function CellRow()
CellRow= Application.Caller.Row
End Function


--
Regards

Haldun Alay

To e-mail me, please replace AT and DOT in my e-mail address with the original signs.



"Haldun Alay" <haldunalayATyahooDOTcom>, iletide sunu yazdi Hi,

Use Application.Caller property.

Function CellRow()
CellAddress = Application.Caller.Row
End Function

when you enter that function in a cell it gives the row number of cell where the function is entered.


--
Regards

Haldun Alay

To e-mail me, please replace AT and DOT in my e-mail address with the original signs.



"Julio Kuplinsky" <[email protected]>, iletide sunu yazdi Is the current cell (not the active cell) available in a
user defined function? For instance, can I say

public function foo()

' Give me the row of the worksheet cell where this
' function is entered

end function

Thanks
 
Back
Top