把VBA修改为VB代码，VBA主要是对单元格计算，赋值，代码中没有窗体，需要修改为vb代码

xhstefanie

代码如下:Sheets("1").Select    Range("C2").Select
    ActiveCell.FormulaR1C1 = _
        "=IF(AND(RC[-1]-R[-1]C[-1]>0,RC[-1]-R[1]C[-1]>0),""GR极大点"","""")"
    Range("D2").Select
    ActiveCell.FormulaR1C1 = _
        "=IF(AND(RC[-2]-R[-1]C[-2]<0,RC[-2]-R[1]C[-2]<0),""GR极小点"","""")"
    Range("E2").Select
    ActiveCell.FormulaR1C1 = "=IF(RC[1]<>"""",RC[-4],"""")"
    Range("F2").Select
    ActiveCell.FormulaR1C1 = _
        "=IF(OR(RC[-3]=""GR极大点"",RC[-2]=""GR极小点""),RC[-4],"""")"
    Range("C2:F2").Select
    Selection.AutoFill Destination:=Range("C2:F3")
    Range("C2:F3").Select
    Selection.AutoFill Destination:=Range("C2:F50000")
    Columns("F:F").Select
    Selection.AutoFilter
    ActiveSheet.Range("$F$1:$F$50000").AutoFilter Field:=1, Criteria1:="<>"
    Range("C1:F50000").Select

    Selection.Copy
    Sheets("2").Select
    ActiveWindow.SmallScroll Down:=-21
    Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("E2").Select
    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = _
        "=IF(AND(RC[-4]=""GR极大点"",RC4-MIN(R[-1]C4:R[1]C4)>R1C10),RC3,"""")"
    Range("F2").Select
    ActiveCell.FormulaR1C1 = _
        "=IF(AND(RC[-4]=""GR极小点"",MAX(R[-1]C4:R[1]C4)-RC4>R1C10),RC3,"""")"
    Range("G2").Select
    ActiveCell.FormulaR1C1 = "=RC[-2]&RC[-1]"
    Range("E2:G2").Select
    Selection.AutoFill Destination:=Range("E2:G35000")
    Range("E2:G35000").Select
    Columns("G:G").Select
    Selection.AutoFilter
    ActiveSheet.Range("$G:$G").AutoFilter Field:=1, Criteria1:="<>"
    Range("A1:D20000").Select
    Selection.Copy
    Sheets("3").Select
    ActiveWindow.SmallScroll Down:=-18
    Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("E2").Select
    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = _
        "=IF(OR(RC[-4]<>R[1]C[-4],RC[-3]<>R[1]C[-3]),(RC[-2]+R[1]C[-2])/2,RC[-2])"
    Range("E2").Select
    Selection.AutoFill Destination:=Range("E2:E5000")
    Range("E2:E5000").Select
    ActiveWindow.SmallScroll Down:=3
    Selection.Copy
    Sheets("4").Select
    ActiveWindow.SmallScroll Down:=-21
    Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("B2").Select
    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = "=R[1]C[-1]"
    Range("B2").Select
    Selection.AutoFill Destination:=Range("B2:B5000")
    Range("B2:B5000").Select
    Range("C2").Select
    ActiveCell.FormulaR1C1 = _
        "=(VLOOKUP(ROUND((RC[-2]+RC[-1])/2,2),R1C[5]:R50000C[6],2)+VLOOKUP(ROUND(RC[-2]+3*(RC[-1]-RC[-2])/7,2),R1C[5]:R50000C[6],2)+VLOOKUP(ROUND(RC[-2]+4*(RC[-1]-RC[-2])/7,2),R1C[5]:R50000C[6],2))/3"
    Range("D2").Select
    ActiveCell.FormulaR1C1 = _
        "=(MAX(R[-1]C[-1]:R[1]C[-1])-RC[-1])/(MAX(R[-1]C[-1]:R[1]C[-1])-MIN(R[-1]C[-1]:R[1]C[-1]))"
    Range("E2").Select
    ActiveCell.FormulaR1C1 = _
        "=LOOKUP(RC[-1],{-999,0.37,0.73,999},{""细"",""中"",""粗""})"
    Range("F2").Select
    ActiveCell.FormulaR1C1 = _
        "=IF(AND(RC[-1]=""粗"",(RC[-3]-RC[1])*R2C10>'2'!R1C10),""中"",IF(AND('4'!RC[-1]=""细"",(RC[1]-RC[-3])*R2C10>'2'!R1C10),""中"",'4'!RC[-1]))"
    Range("G2").Select
    ActiveCell.FormulaR1C1 = _
        "=IF(RC[-2]=""细"",(LARGE(R[-1]C[-4]:R[11]C[-4],1)+LARGE(R[-1]C[-4]:R[11]C[-4],3))/2,(SMALL(R[-1]C[-4]:R[11]C[-4],1)+SMALL(R[-1]C[-4]:R[11]C[-4],3))/2)"

    以上为部分代码，麻烦大神修改到VB能用的代码。我是个vb大白。vba也只是皮毛。

xhstefanie

哪些代码是需要修改的？