ExcelBanter - View Single Post - Sending the current row number as a parameter to a function

[email protected]

Yes

=samplefunction(row())

wrote:
Thanks DAD,
but can i send the result of =ROW() as a parameter in my own function?

Die_Another_Day wrote:
Try the Row() function. To test, in a cell type =Row() and press enter

Charles

wrote:
Hi,
This is my first post.
I have a simple VBA function that counts the number of colored cells
(of a certain color), and prints in to the cell which activates the
function.
It works fine but i want change the function så that will become more
'general', meaning that i'll be able to use it from meny other cells.
I want to know if there is any way to sent somthing like
functionName(currentCellRowNumber) insted of functionName(36) like i do
now where i have to change the number manually every time.
I'll appreciate any help i can get.