Makro abkürzen
19.05.2005 16:00:17
Eva
gibt es Möglichkeiten den Code zu verkürzen, damit es schneller abläuft?
Gruß
Eva
Dim ztdv As Integer, stdv As Integer
Dim ztmaster As Integer, stmaster As Integer
Dim toolset As Worksheet
Dim docview As Worksheet
Set toolset = Workbooks("Auswertung CB FEE 19052005.xls").Worksheets("ToolsetWF@1st Run Refurb 26.Feb")
Set docview = Workbooks("Auswertung CB FEE 19052005.xls").Worksheets("DocView")
ztdv = 3
stdv = 3
For ztmaster = 5 To 149
'hieran Code für die Farben schließen einzeln if aufdröseln
If toolset.Cells(ztmaster, 99) = "" Or toolset.Cells(ztmaster, 100) = "" Or toolset.Cells(ztmaster, 101) = "" Or toolset.Cells(ztmaster, 102) = "" Or toolset.Cells(ztmaster, 103) = "" Or toolset.Cells(ztmaster, 104) = "" Then
docview.Cells(ztdv, 1) = toolset.Cells(ztmaster, 14) 'area
docview.Cells(ztdv, 2) = toolset.Cells(ztmaster, 171) 'CB name
docview.Cells(ztdv, 3) = toolset.Cells(ztmaster, 17) 'toolcode Kulim
docview.Cells(ztdv, 4) = toolset.Cells(ztmaster, 97) 'PCN
'A vendor
docview.Cells(ztdv, 5) = toolset.Cells(ztmaster, 99) 'CEPS BPA
docview.Cells(ztdv, 6) = toolset.Cells(ztmaster, 100) 'Ammendment
docview.Cells(ztdv, 7) = toolset.Cells(ztmaster, 101) 'TPS
docview.Cells(ztdv, 8) = toolset.Cells(ztmaster, 102) 'TOS200
docview.Cells(ztdv, 9) = toolset.Cells(ztmaster, 103) 'GER
docview.Cells(ztdv, 10) = toolset.Cells(ztmaster, 104) 'TGTS
docview.Cells(ztdv, 11) = toolset.Cells(ztmaster, 105) 'A vendor list price
docview.Cells(ztdv, 12) = toolset.Cells(ztmaster, 106) 'currency
docview.Cells(ztdv, 13) = toolset.Cells(ztmaster, 115) 'vendor name
'B vendor
docview.Cells(ztdv, 15) = toolset.Cells(ztmaster, 117) 'CEPS BPA
docview.Cells(ztdv, 16) = toolset.Cells(ztmaster, 118) 'Ammendment
docview.Cells(ztdv, 17) = toolset.Cells(ztmaster, 119) 'TPS
docview.Cells(ztdv, 18) = toolset.Cells(ztmaster, 120) 'TOS200
docview.Cells(ztdv, 19) = toolset.Cells(ztmaster, 121) 'GER
docview.Cells(ztdv, 20) = toolset.Cells(ztmaster, 122) 'TGTS
docview.Cells(ztdv, 21) = toolset.Cells(ztmaster, 123) 'A vendor list price
docview.Cells(ztdv, 22) = toolset.Cells(ztmaster, 124) 'currency
docview.Cells(ztdv, 23) = toolset.Cells(ztmaster, 133) 'vendor name
' C vendor
docview.Cells(ztdv, 25) = toolset.Cells(ztmaster, 135) 'CEPS BPA
docview.Cells(ztdv, 26) = toolset.Cells(ztmaster, 136) 'Ammendment
docview.Cells(ztdv, 27) = toolset.Cells(ztmaster, 137) 'TPS
docview.Cells(ztdv, 28) = toolset.Cells(ztmaster, 138) 'TOS200
docview.Cells(ztdv, 29) = toolset.Cells(ztmaster, 139) 'GER
docview.Cells(ztdv, 30) = toolset.Cells(ztmaster, 140) 'TGTS
docview.Cells(ztdv, 31) = toolset.Cells(ztmaster, 141) 'A vendor list price
docview.Cells(ztdv, 32) = toolset.Cells(ztmaster, 142) 'currency
docview.Cells(ztdv, 33) = toolset.Cells(ztmaster, 151) 'vendor name
' D vendor
docview.Cells(ztdv, 35) = toolset.Cells(ztmaster, 153) 'CEPS BPA
docview.Cells(ztdv, 36) = toolset.Cells(ztmaster, 154) 'Ammendment
docview.Cells(ztdv, 37) = toolset.Cells(ztmaster, 155) 'TPS
docview.Cells(ztdv, 38) = toolset.Cells(ztmaster, 156) 'TOS200
docview.Cells(ztdv, 39) = toolset.Cells(ztmaster, 157) 'GER
docview.Cells(ztdv, 40) = toolset.Cells(ztmaster, 158) 'TGTS
docview.Cells(ztdv, 41) = toolset.Cells(ztmaster, 159) 'A vendor list price
docview.Cells(ztdv, 42) = toolset.Cells(ztmaster, 160) 'currency
docview.Cells(ztdv, 43) = toolset.Cells(ztmaster, 169) 'vendor name
End If
ztdv = ztdv + 1
Next ztmaster
End Sub