Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Search results for query: *

  1. ab123456

    Change order of attribute prompt when inserting a block

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

    MAX function

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

    MAX function

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

    MAX function

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

    Open Text File with Excel Macro

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

    Opening a text file using a macro

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

    Vertical cell movement?

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

    Finding empty cells

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

    Date formatting

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

    Date formatting

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

    VBA ComboBox Problem?

    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"...
  12. ab123456

    Opening new workbooks in excel

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

    VBA UserForms in Excel

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

    VBA UserForms in Excel

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

    VBA UserForms in Excel

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

    Filtering for words within cells

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

    Thermal relief

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

    Thermal relief

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

    Automatic formatting of significant figures

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

    Selecting cells in Excel using variables

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

Part and Inventory Search

Back
Top