Creating function for cell
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Creating function for cell

  1. #1


    How can I change a working macro (sub) into one I can place in a cell? Such as SUM()???

  2. #2


    You declare it as a Public Function. Instead of having it in a Sub, you would have it in a Public Function.

    for example, put this in a standard module:

    Public Function MySum(TgtRange As Range) As Long

    Dim Rng As Range
    Dim TempAns As Long

    For Each Rng In TgtRange
    TempAns = TempAns + Rng.Value

    MySum = TempAns

    End Function

    To use this function simply type in "=MySum(XX:XX)", where "XX:XX" is the range that you'd like to get the sum of.


  3. #3


    Man, is my face red! THANKS...

    (is there a way to set when these functions are activated? I am monitoring the length of a table for a %, can I set it so it will run when the table length cahnges-- or is that not needed?)

    Again Thanks for the help...

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts