Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Current year and current week number | Excel Discussion (Misc queries) | |||
How to count a range of number to a given parameter or criteria. | Excel Worksheet Functions | |||
How do you return current ROW number to definition in NAME function? | Setting up and Configuration of Excel | |||
Sending a parameter to a Userform | Excel Programming | |||
Format when sending a range as parameter to a custom function | Excel Programming |