Recent content by briand2

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

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

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...

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...

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...

That's really helpful, thank you! Regards, Brian

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

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...

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...

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...

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...

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...

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...

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

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