cmdCombineRoadway Macro

[samlrun]

High Level Issue

This code is written for one specific file. It would be better to adjust it for new FC data. Found in the form_CreateIntData module. (note: I believe there may be a similar chunk of code written just like this somewhere else in the project)

    Rows("1:2").Delete shift:=xlUp                                                      'FLAGGED: This code seems a bit arbitrary
    Range("I11").Copy
    Range("A1:G573").PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False
    ActiveSheet.Shapes.Range(Array("sort.gif")).Delete
    ActiveSheet.Shapes.Range(Array("mnu_sort_asc.gif")).Delete
    Rows("574:574").Delete shift:=xlUp