Search results for query: *

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

Thats what im looking for. I think i need to do a bit of research about array functions. Thanks

Thanks for the speedy reply. Its a sheet that will be used by others in the company so i want to make it as simple to look at and understand as possible so i want to avoid unnecessary columns if i can. I could always hide the surrogate column but is there a more elegant solution that anybody...

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

Have you tried starting the macro recorder and then opening the file and modifying the code. Ive done this previously when my text file has been comma delimited and extracted the following code Workbooks.OpenText sfilename, DataType:=xlDelimited, Comma:=True, FieldInfo:=Array(Array(1...

If you know the file you wish to open you can use Workbboks.OpenText sFilename where sFilename is the full path and file name of the path to open If you dont know the name of the file to open put the following line of code before the Workbooks.opentext line sFilename =...

Go Tools >>> Options >>> Select 'Edit' tab. Then change Move Selection after Enter to right.

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

CajunCenturion : My language options in control panel is set dd/mm/yyyy Timberframe : I am on 2003. I have a sheet with about 20000 rows so doing each cell manually would take me for ever and this is an activity i need to do regularly. Also as the format isnt consistent within each column 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...

In your combobox change the additems to "Steel" etc Then in the commandbutton1_click procedure use the select...case statement to set your value Select Case ComboBox1.Value Case "Steel" numerical_value = 7.85 Case "Aluminium" numerical_value = "2.60"...

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

correction to above post As the listindex returns 0 for item at top of list but your original data only starts at row 2, the code should read row_number = ListBox1.ListIndex + 2

Firstly you need to find which row the result of your listbox is in. If the data in the listbox is the same order as the data on your sheet you can use the listindex property. This would return 0 if the first item in the list is selected, 1 if the second item is selected and so on. Then a line...

At the moment the clicking of the buttons doesnt run any code. You need some code in the sub commandbutton1_click(), something like Sheets("sheet1").Cells(8, 1).Value = ListBox1.Value

It looks like you already have an answer but if you want to filter in place the advanced filter feature in excel can do exactly what you are looking for.

Montemayor, Thanks for your reply I appreciate your assistance. The line in question will be used to transfer acetaldehyde from storage tanks to various locations around site, the boiling point of the material is 21degc. The scenario i am concerned with is after a transfer valves are closed...

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

For those who arent familiar with VB you can use =IF(A1>1,ROUND(A1,A2-(LEN(INT(A1))),ROUND(A1,A2)) Where the number is in A1 and A2 contains the number of significant digits you want to round to.

Use Range(Cells(1, 1), Cells(i, 8)).Select