VBA kürzer damit Makro schneller wird
06.11.2014 00:45:34
mehmet
wie könnte man das Makro mit Schleife verkürzen:
Sheets("OL_test_OneLeg3d").Range("g3") = "=IF(n3="""","""",IF(n3=""- "","""",IF(IF(n3=""- "","""",MOD(m3-n3,1))<IF(n3=""- "","""",MOD(n3-m3,1)),"" - "","" + "")))"
Sheets("OL_test_OneLeg3d").Range("g4") = "=IF(n4="""","""",IF(n4=""- "","""",IF(IF(n4=""- "","""",MOD(m4-n4,1))<IF(n4=""- "","""",MOD(n4-m4,1)),"" - "","" + "")))"
Sheets("OL_test_OneLeg3d").Range("g5") = "=IF(n5="""","""",IF(n5=""- "","""",IF(IF(n5=""- "","""",MOD(m5-n5,1))<IF(n5=""- "","""",MOD(n5-m5,1)),"" - "","" + "")))"
Sheets("OL_test_OneLeg3d").Range("g6") = "=IF(n6="""","""",IF(n6=""- "","""",IF(IF(n6=""- "","""",MOD(m6-n6,1))<IF(n6=""- "","""",MOD(n6-m6,1)),"" - "","" + "")))"
Sheets("OL_test_OneLeg3d").Range("g7") = "=IF(n7="""","""",IF(n7=""- "","""",IF(IF(n7=""- "","""",MOD(m7-n7,1))<IF(n7=""- "","""",MOD(n7-m7,1)),"" - "","" + "")))"
Sheets("OL_test_OneLeg3d").Range("g8") = "=IF(n8="""","""",IF(n8=""- "","""",IF(IF(n8=""- "","""",MOD(m8-n8,1))<IF(n8=""- "","""",MOD(n8-m8,1)),"" - "","" + "")))"
Sheets("OL_test_OneLeg3d").Range("g9") = "=IF(n9="""","""",IF(n9=""- "","""",IF(IF(n9=""- "","""",MOD(m9-n9,1))<IF(n9=""- "","""",MOD(n9-m9,1)),"" - "","" + "")))"
Meine Laufvariable von oben nach unten heisst eigendlich "k"
Ich kriege es nicht hin in die Formel einzubinden.
herzlichen Dank
Gruss
mehmet