Please refer Para 419.6.4 of B31.4 which differentiates between the restrained portion and unrestrained portion of a pipeline for the calculation and evaluation of the stresses resulting from temperature and pressure changes in the line. For restrained portion, the longitudinal compressive...
Please refer Para 419.6.4 of B31.4 which differentiates between the restrained portion and unrestrained portion of a pipeline for the calculation and evaluation of the stresses resulting from temperature and pressure changes in the line. For unrestrained portion the longitudinal compressive...
If still seeking the solution then I suggest to use Excel object model within your VBA code. If you can specifically mention the problem then I can suggest you more speific solution.
When there is no bellow in the system, there are two opposit forces acting on the nozzle. One is the thrust force exerted on the elbow or tee equal to P * pipe cross sectional area, and other is the net thrust force acting on the pump equal to P * nozzle cross sectional area. Normally the two...
With DAO you can accomplish it as by sample code in the This File . You need to create reference to DAO ( by Tools-->Preferences)before executing such code that refers to DAO Object model
A quick manual method would be to select the cells, change the format by Format --> Cells and then repeatedly pressing the keys of F2 and {ENTER}, alternately, untill done. Here F2 is keyboard shortcut to enter edit mode of cell and {ENTER} key is to go to next cell.
To avoid the lobor of...
No these disadvantages are not there. However, I would be better to modify the code as under
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim WinState, MyWin As Window
ActCol = Target.Column
ActRow = Target.Row
Set MyWin = ThisWorkbook.Windows(1)
Application.ScreenUpdating =...
You can use conditional formating features and specify following two conditions, for entire sheet cells, with appropriate cell format
Condition 1
Formula Is =ROW()=activerow()
Condition 2
Formula Is =Column()=activecol()
whre ActiveRow and ActiveCol are two functions defined in a module as...