Befel optimieren
12.09.2013 11:22:14
Volker
läßt sich diese Befehlsstange kürzer schreiben? Die Zahlenfolge geht chronologisch weiter.
Danke für die Hilfe. Gruß Volker
Range("C1") = "=INDIRECT(""A25"")"
Range("C2") = "=INDIRECT(""A26"")"
Range("C3") = "=INDIRECT(""A27"")"
Range("C4") = "=INDIRECT(""A28"")"
Range("C5") = "=INDIRECT(""A29"")"
Range("C6") = "=INDIRECT(""A30"")"
Range("C7") = "=INDIRECT(""A31"")"
Range("C8") = "=INDIRECT(""A32"")"
Range("C9") = "=INDIRECT(""A33"")"
Range("C10") = "=INDIRECT(""A34"")"
Range("C11") = "=INDIRECT(""A35"")"
Range("C12") = "=INDIRECT(""A36"")"
Range("C13") = "=INDIRECT(""A37"")"
Range("C14") = "=INDIRECT(""A38"")"
Range("C15") = "=INDIRECT(""A39"")"
Range("C16") = "=INDIRECT(""A40"")"
Range("C17") = "=INDIRECT(""A41"")"
Range("C18") = "=INDIRECT(""A42"")"
Range("C19") = "=INDIRECT(""A43"")"
Range("C20") = "=INDIRECT(""A44"")"
Range("C21") = "=INDIRECT(""A45"")"
Range("C22") = "=INDIRECT(""A46"")"
Range("C23") = "=INDIRECT(""A47"")"
Range("C24") = "=INDIRECT(""A48"")"