Results 1 to 1 of 1
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The attached document contains crude code “ImplementTableFunction” to implement a table function scheme, solely for SUM with a format “#,##0”.
    Quick Start: Select the SIX table cells in the rightmost column for rows 2 through 7. Run the macro “test”. A table cell formula showing a result “6” should appear in the cell in row 7.
    The formula generated can be dragged outside the column, and you can see that I have done this with each block of cells corresponding to a deliverable milestone in the project.
    When you are done, select all cells in the rightmost column except the last cell. Run the macro “test”. A table cell formula showing a result “55” should appear in the last cell of the table.

    The code contains limited error-checking.
    For example, it assumes that there will be an empty cell below the selected set of cells.
    Code:
        '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
        ''' Function:   ImplementTableFunction
        '''
        ''' Comments:   Build a table function for a given range
        '''
        ''' Arguments:  RANGE           A rectangular range of table cells.
        '''             STRING          The string representation of a function e.g. "SUM"
        '''             STRING          The string representation of a format e.g. "#,##0"
    Attached Files Attached Files

Posting Permissions

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