I'm trying to write a code to copy a worksheet, do something and then delete it. Problem is I get this prompt before the sheet is deleted:
"Data may exist in the sheet(s) selected for deletion.To permanently delete the data, press delete."
How do I get my code to avoid that prompt or...
Is it possible to enter a serie of numbers - comma separated - in one cell and then use this "string" as an array in another formula?
For example:
In cell A1 I enter 1,0,0,1,1,1,0
In cell B1 I enter =sum(A1) and the result should have been 4.
I know this doesn't work, but the question is is...
Hello all
The european piping code EN 13480 has now got an official Questions & Answers Web site at:
http://comelec.afnor.fr/servlet/ServletComelec?form_name=cFormIndex&login=invite&password=invite&organisme=cen&comite=en13480
It is so new (or unknown) that the first question has not yet been...
Does anybody have experience on how to categorize concentrated acids or bases in the PED fluid group system?
In the PED text at http://ped.eurodyn.com/directive/directive_article9.html
there’s a reference to 67/548/EEC which includes corrosive fluids as being dangerous, however there is no...
Does anyone know the basic steps on how to create a custom help file for excel, e.g. for use with a User Defined Function? Also if any additional software is required apart from thet included in the office package.
regards
Mogens
Does anybody know of any educational institutes which offer courses in the new european piping code EN13480?
I've been through some parts of it on a self study basis, but might get permission to attend a full course, however so far I haven't been able to find anyone offering it.
Regards
Mogens
This is just to replace my old thread about a free flange spreadsheet.
Everybody interested can download a copy from
http://www.mxl.dk/Download%20Files/Flange%20Calculation.htm
Please download also the readme file and the comment file, to see any comments on possible errors received from...
Does anybody know what software can be used to open a file named .ica, without having to purchase the software itself.
Apparently it comes from a supplier at www.citrix.com
Sometimes you kan get free downloadable "viewer" files. Is this possible here?
regards
Mogens
When calculating flanges according to ASME VIII, div 1, appendix 2, in some cases the bolting will fail even when using the tabulated pressure ratings of ASME B16.5. The allowable bolt stresses have been obtained from ASME B31.3 as defined in section 304.5.1.
As an example a 12” 2500# RTJ...
Can anyone tell me if there is a way to avoid getting an error message when using a user defined function to refer to a named range?
Say I have three named ranges:
A1:A5 named "Name1"
B1:B5 named "Name2"
C1:C5 named "Name3"
-all cells filled with numbers
Then I...
This may be an odd one and I'm not sure if this the right forum but anyway...
I had a discussion with my colleagues about which way is the correct to specify angles when you specify nozzle orientations on vessel heads:
1. Should 0 degrees start at the X-axis or the Y-axis?
2. Should the...
Just found this link which I think could be useful to many
http://www.welding-units.co.uk/dld/dld.htm
This program has got dimensions for ANSI/API flanges as well as Taperlok and compact flanges
regards
Mogens
My computer was upgraded to Windows XP today via my network login. This included an Excel upgrade to version 2002.
I then have a file with an autofilter applied.
When I work in this suddenly after a while the autofilter just "freezes", i.e. the filter buttons does not react at all.
I...
I have a spreadsheet with an autofilter applied.
When I set the filter, the staus bar shows "Filter Mode"
On other spreadsheets with filtered lists, the status bar shows "xx of yy records found"
Why doesn't my first sheet show the same and how do I change it to make the...
A colleague of mine have been asked if he could establish a computer program for optimising usage of pipes when cutting.
The problem:
Pipes on stock exist in a number of random lengths, typically 6m but with some variations.
Pipes for fabrication needs to be cut into specific lengths normally...
A colleague of mine have been asked if he could establish a computer program for optimising usage of pipes when cutting.
The problem:
Pipes on stock exist in a number of random lengths, typically 6m but with some variations.
Pipes for fabrication needs to be cut into specific lengths normally...
Hello all
I just stumbled over some notes from a course about the new european pressure vessel code EN13445, which lists the source of the different sections in the code, and I assume this may be of interest to some of you.
The notes were made when the code was still preliminary - thus the...
Does anyone know if (and how) it is possible to link a picture (or embedded object) to a formula, e.g. an if statement?
This way it could be possible e.g. to show one picture if cell a:1=1 and another picture if cell a:1 = 2.
Any suggestions?
Mogens
We have a discussion about the various development phases of a P&ID, especially when going from one design phase to another.
The terms "Approved for design" and "Approved for Construction" are often used as milestone terms, however the ecpected level of completion is not...
I made a User defined function which returns the position of "Value" in an index, using the Excel function Match:
Public Function MyFunction(Value)
Dim vaNumber As Integer
Dim rgLookupRange As Range
Set rgLookupRange =...
