Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by briand2

  1. briand2

    Excel for Simple Pipe Network; Finding Largest Draw-off (Tap / Faucet) Served via Each Flow Pipe

    Third approach...using MaxFlowAlt UDF.http://files.engineering.com/getfile.aspx?folder=c33cf03c-4769-4703-8791-eec882ba409c&file=pipe_find_max_draw_off_wip_with_udf_maxflowalt.xlsm
  2. briand2

    Excel for Simple Pipe Network; Finding Largest Draw-off (Tap / Faucet) Served via Each Flow Pipe

    Second approach...using MaxFlow UDF.http://files.engineering.com/getfile.aspx?folder=4bc184a8-39e4-4a81-8caa-f07e239afd3c&file=pipe_find_max_draw_off_wip_with_udf_maxflow.xlsm
  3. briand2

    Excel for Simple Pipe Network; Finding Largest Draw-off (Tap / Faucet) Served via Each Flow Pipe

    Skip, Sorry for delayed reply - Bank Holiday long Easter weekend in UK (although I've been busy on this as described below!). I didn't mean that I had managed to carry out this particular task without VBA, I just meant that over the years I'd managed to supersede other VBA routines in the...
  4. briand2

    Excel for Simple Pipe Network; Finding Largest Draw-off (Tap / Faucet) Served via Each Flow Pipe

    Skip, Thank you for your help. I had hoped (over-optimistically) to achieve it without resorting to VBA, but I agree with you that it's just not possible (although I spent quite a few hours going round in circles trying to achieve it!). I used to have some of my own VBA including UDF's in this...
  5. briand2

    Excel for Simple Pipe Network; Finding Largest Draw-off (Tap / Faucet) Served via Each Flow Pipe

    I am carrying out some analysis of pipe networks. Although I have over the years developed an increasingly sophisticated (some might say complex and cumbersome!) Excel spreadsheet for this, there is one particular aspect that I have been struggling with recently. Let me explain... The attached...
  6. briand2

    Meaning of "." between terms in Fortran

    That's really helpful, thank you! Regards, Brian
  7. briand2

    Meaning of "." between terms in Fortran

    I am trying to understand some Fortran code that contains the following: IF(NT.NE.0) GO TO 15 Could someone please explain this "." operator is / does? Thank you. Brian
  8. briand2

    Xcel 2007Fill details from sheet 1 to sheet 2

    If the Sheet 1 data is in tabular format, with one row per member and unique membership number on the left-most column, then you could use VLOOKUP: Say, for example, all Sheet 1 data is in range A1:F10, with column A holding unique membership number and column C holding house number and column...
  9. briand2

    Excel 2003; Display Selected Range's Name In Name Box

    Ken, I've just realised that it only works if the range comprises just one area, i.e. if the cells are contiguous. If the cells are not contiguous, then the name of the range does not get displayed in the Name Box when the range is selected. I've also just tried this in Excel 2000, with...
  10. briand2

    Excel 2003; Display Selected Range's Name In Name Box

    Although I can use the drop down list from the Name Box to select a named range, once that range is selected the Name Box does not display the name of the range, but only the address of one of the cells in the range. Is there any way I can get the Name Box to display the name of a selected...
  11. briand2

    Force Outlook 2000 To Prompt For Account When Sending Mail

    Thanks, Boni. It's OK - I've found a way of doing it!! I just used Tools\Customise, selected Commands tab and under the File menu item found command Send Using, which I dragged to the top left of my tool bar. This new command is now to the left of my pre-existing, normal Send button. When I...
  12. briand2

    Force Outlook 2000 To Prompt For Account When Sending Mail

    I use Outlook 2000 at home and I have several email accounts. Almost all of the time I send emails from my default account. However, on some occasions I need to send it from a different account. I know all I have to do is click the down-arrow beside the Send button and then select the...
  13. briand2

    Can I put a picture in Excel 2000 Header?

    Thanks for the quick responses! Wrbnoh: Unless I'm missing something, the Header setup dialog box in Excel 2000 does not have a "picture icon"; I believe that did not come until Excel 2002? BlueHorizon: Your workaround of putting the picture in the repeated top rows instead of in the...
  14. briand2

    Can I put a picture in Excel 2000 Header?

    Could someone please advise me if it is possible to put a picture / graphic in Excel 2000 header. I've tried to copy and paste, but I don't get the "Paste" option available when the header is selected. Thanks in advance, Brian
  15. briand2

    Register MSCAL.OCX for Excel without Access present

    IonFilipski Thank you very much for your prompt reply. I did what you said and it's now working perfectly! Brian
See more

Part and Inventory Search

Back
Top