Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

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

Recent content by joerd

  1. joerd

    velocity criteria for PSV suction line

    No, there is just the "3%" rule, see API 520. 70% of sonic is way too high. Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
  2. joerd

    How to create a simulation model for isenthalpic (adiabatic) flash?

    Just use a valve operation. Your inlet stream is fully specified: composition, temperature, and pressure. The outlet stream pressure should be specified at the 90% value, the temperature will be calculated. The flow rate is not important, so just pick a number. Make sure you use a steam property...
  3. joerd

    Transposing data from columns

    Since we're off on a tangent, here are two more solutions to the problem, one using DGET, and one using a pivot table. Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of...
  4. joerd

    Transposing data from columns

    Yes, works if you have Excel 2007. Otherwise, it becomes very cumbersome. Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
  5. joerd

    Transposing data from columns

    Use a Pivot table. No VBA required. Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.http://files.engineering.com/getfile.aspx?folder=05eda52d-9a48-484a-af2b-258adb5ea48e&file=Pivot-example.xls
  6. joerd

    Text Formatting to the Result of a Formula

    Not that I know of. You may consider putting the =TEXT(A1,"0.0") in one cell, and x B2 in the cell just to the right of it. Then you can format B2 whichever way you want. Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
  7. joerd

    Can't change borders of unlocked & unprotected cell

    Couple of thoughts: - you may have Window/Freeze Panes on - did you try copying everything to a new sheet? Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
  8. joerd

    Which event?

    You can accomplish the same using the Workbook_SheetChange event in the ThisWorbook module. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) MsgBox ("You changed " & Sh.Name & " cell " & Target.Address) End Sub Cheers, Joerd Please see FAQ731-376 for tips on how...
  9. joerd

    Can get carriage return to work

    You wrote a nice replacement for the Replace method. The short version is: strATextValue = Replace(strATextValue, vbLf, vbCr) Modify as needed, it's pretty flexible. Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
  10. joerd

    Can get carriage return to work

    In Word, a new line is entered using Selection.TypeParagraph. So you will have to split up the Excel cell value at vbLF (or chr(10), it's the same), and then use Selection.TypeText Text:="first part" Selection.TypeParagraph Selection.TypeText Text:="second part" So your code...
  11. joerd

    Reference to multiple workbooks?

    You can set up a database query instead. Go to Data/Import External Data/New Database Query... and link to the spreadsheets. It helps if the source spreadsheets have range names defined for the exported data. Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
  12. joerd

    Problem with Files

    The spreadsheet is linked to a spreadsheet "Bearing .xls", which I don't have, but it tries to open it. So, if that links to several other files, and they automatically open, you get what you observe. Check the list of links under the Edit menu, option Links... Cheers, Joerd Please see...
  13. joerd

    Getting rid of plot markers and labels

    Instead of For Each ThisDataLabel In ThisSeries.DataLabels ThisDataLabel.Delete Next ThisDataLabel try ThisSeries.HasDataLabels = False Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
  14. joerd

    Excel - Semi Log Plot

    To add to this: if you ever decide to try VBA, be aware that LOG is the natural logarithm in Visual Basic. Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
  15. joerd

    Excel formula problem

    @mortenA This may be helpful: an up-to-date dictionary for Excel 2007 functions with 14 languages: http://www.piuha.fi/excel-function-n...languages.html Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
See more

Part and Inventory Search

Back
Top