|
代码如下: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也只是皮毛。
|
|