+ Reply to Thread
Results 1 to 19 of 19

cell references help needed

Hybrid View

  1. #1
    Registered User
    Join Date
    07-05-2011
    Location
    Armidale, Australia
    MS-Off Ver
    Excel 2007
    Posts
    12

    Thumbs up Re: cell references help needed

    Hi Huron
    Back in my office after the weekend.
    I've made a copy of the relevant part of the sheet with data for M=5. The sub CalcSS() in the solve module for the case 5 (ie M=5) works OK with the specific code for M=5.
    I have commented out the more generic code I was trying to create, with your help, for M = anything from 2 to 15. teh geenric code does not currently work. What would be helpful is getting the generic code that uses pred to work. I would then replace all the specific code for cases 2 to 15 with this (i've coded cases 2-6 so far). You may need to add in solver.xla to project references to enable solver to run.
    Look forward to seeing what you can come up with.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1