Hi,
Below is the first VBA code I have created individually, but it seems "slow."
Any suggestions oh how to revise for optimization?
Sub Iteration()
' Insert New Row
ActiveCell.Offset(1, 0).Rows("1:1").EntireRow.Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
' Copy Subcontractor
ActiveCell.Offset(-1, 0).Range("A1").Select
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
' Generate New Number
ActiveCell.Offset(-1, 1).Range("A1").Select
Application.CutCopyMode = False
Selection.AutoFill Destination:=ActiveCell.Range("A1:A2"), Type:= _
xlFillDefault
' Copy Spec Division
ActiveCell.Range("A1:A2").Select
ActiveCell.Offset(0, 1).Range("A1").Select
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
' Copy Division Title
ActiveCell.Offset(-1, 1).Range("A1").Select
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
' Copy Spec Section
ActiveCell.Offset(-1, 1).Range("A1").Select
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
' Copy Section Title
ActiveCell.Offset(-1, 1).Range("A1").Select
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
' Copy Submittal
ActiveCell.Offset(-1, 1).Range("A1").Select
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
' Generate New Status
ActiveCell.Offset(0, 2).Range("A1").Select
ActiveCell.FormulaR1C1 = "UNS"
' Copy Spec Verbiage
ActiveCell.Offset(-1, 6).Range("A1").Select
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
' Exist Copy/Paste Sequence
Application.CutCopyMode = False
' Hide Old Row
ActiveCell.Offset(-1, 0).Rows("1:1").EntireRow.Select
Selection.EntireRow.Hidden = True
' Return to Start of Next Row
ActiveCell.Offset(1, 0).Range("A1").Select
End Sub
If any additional information is needed, please let me know.
Thanks,
TW
Bookmarks