I have created a block with a number of attributes but when I insert this block into a drawing the order in which I am prompted to complete the attributes is confusing.
Is there a method of changing the order in which I am prompted for this data?
Thanks
I have a sheet that performs calculations on a series of data and then uses the MAX function to identify the highest result.
My problem is that in the range of data in which im trying to find the max I have cells containing #value and #ref. Is there any way that i canignore (or treat as zero)...
I have a range of data but within this range there are some empty cells, some cells containing text and others with numbers. How can I find the first empty cell within each column? Say my data was in range A1:B25 wth cells A3 and B15 empty I want cell A26 to display 3 and B26 to display 15.
I...
I have a list of data in excel with the data arranged in rows, the data is a mix of text, numbers and dates. When i open the file and examine the data everything is fine.
Now the problem ... I want to move this worksheet on to a new sheet in an existing workbook, i use the edit >>>> move/copy...
I am trying to open a new file within excel when running a macro. The file to open will have a different name each time so i require the user to input the filename. The file will always be a comma separated text file. I need the file to open in excel without having to go through the text import...
I have a pipe containing material at a temperature very close to its boiling point. On a hot sunny day the ambient temperature may exceed the boiling point of the material.
We will be fitting thermal relief valves however am unsure on how to size these. If I can quantify the solar heat gain i...
I am trying to use the advanced filter in excel to extract some data from a large file. My question is how do I filter a column so it shows only data that does not contain a particular text string?
I know this can be done realtively simply using the AutoFilter function but this is only a part...
Say I had a number of different object and each of these objects could take a different value, how can I create a list of all possible combinations?
I think maybe an example is needed here, say I have one object called A that can take a value between 1 and 3 and object B which can be either 1...
How can I determine whether I need to fit thermal relief valves to pipe runs?
There is no consistency on site at the moment and each engineer has a different opinion so we are trying to settle an arguement and set up some site standards.
The lines in questions are typically 8" stainless steel...
We have a number of atmospheric storage tanks at our site by the sea. It is not unusual for waves to come over the sea defences onto site. The question has been asked what would happen in a freak storm and in particular the chances of a wave of such force that it will cause the vessel to...
I have a macro that deletes a sheet from the workbook if a certain event occurs. This is done by the code
Sheets("OldSheet").delete
the problem is that Excel prompts the user to confirm delete, is there a way i can stop this message popping up and delete the sheet without prompting...
I have a project containing hidden worksheets, depending on the users action I need to copy and modify a hidden worksheet. Both the original and modified sheet need to remain hidden.
I have used the code
'Sheets("BlankData").Copy Before:=Sheets(1)'
to copy the worksheet but i now...
Now that the new ATEX regulations are in force here in europe i was wondering whether anybody has any experience about buying equipment from the US.
We are wanting to buy a skid mounted system containing a number of items of rotating equipment for use in a hazardous area, previously we would...
I have a macro in excel that is used to save the excel file to my a: drive when a certain sequence of events occur. My problem is that if there is no floppy in the drive i get an error message that allows me to retry or cancel. If i cancel it returns me to the debug screen.
Is there any way i...
We have a number of storage vessels that are used for various solvents contained in a bund of approx 4" depth. All electrical items located in the bund are EEx rated for a zone 2 area. My question is whether the zoned area should continue beyond the confines of the bund and if so how to I...
