Design Excel Macro to find the word "Weld" and insert a blank row.
$10-30 USD
Terminado
Publicado hace alrededor de 9 años
$10-30 USD
Pagado a la entrega
Design Excel Macro to find the word "Weld", "Bend", "Flange", or "Valve" and insert a blank row below. Then enter the word "Pipeline" under those words and move the information next to "Weld", "Bend", "Flange", or "Valve" next to the word pipeline just below. Please see examples attached. Also below is part of the macro
Sub BlankLine()
Dim Col As Variant
Dim BlankRows As Long
Dim LastRow As Long
Dim R As Long
Dim StartRow As Long
Col = "E"
StartRow = 1
BlankRows = 1
LastRow = Cells([login to view URL], Col).End(xlUp).Row
[login to view URL] = False
With ActiveSheet
For R = LastRow To StartRow + 1 Step -1
If .Cells(R, Col) = "0" Then
.Cells(R, Col).[login to view URL] Shift:=xlDown
End If
Next R
End With
[login to view URL] = True
End Sub
Happy to help you with this macro now
.................................................................................................................