Results 1 to 6 of 6

Thread: Autoselect relevant range for Sumproduct function

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 06-30-2009, 07:56 AM #5
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,476
    Location
    A non macro solution, using a few helper cells
    Last edited by mdmackillop; 06-30-2009 at 08:05 AM. Reason: Sample tidied
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules