Wert übernahme
21.11.2003 09:15:08
Nabriss
Mappe1.xls und Test.xls
Wie geht so was mit eine schleife
Range("A1") = "=[Test.xls]Tabelle1!R1C1"
Range("A2") = "=[Test.xls]Tabelle1!R2C1"
Range("A3") = "=[Test.xls]Tabelle1!R3C1"
Range("A4") = "=[Test.xls]Tabelle1!R4C1"
Range("A5") = "=[Test.xls]Tabelle1!R5C1"
Range("A6") = "=[Test.xls]Tabelle1!R6C1"
Range("A7") = "=[Test.xls]Tabelle1!R7C1"
Range("A8") = "=[Test.xls]Tabelle1!R8C1"
Range("A9") = "=[Test.xls]Tabelle1!R9C1"
Gruß
Nabriss