Weiß nicht wie ich es beschreiben soll
26.07.2003 20:16:31
Karsten J.
In einem Macro habe ich folgendes Script:
Cells(1, 25).Select
a1 = ActiveCell.Value
Cells(2, 25).Select
a2 = ActiveCell.Value
Cells(3, 25).Select
a3 = ActiveCell.Value
Cells(4, 25).Select
a4 = ActiveCell.Value
Cells(5, 25).Select
a5 = ActiveCell.Value
Cells(6, 25).Select
a6 = ActiveCell.Value
Cells(7, 25).Select
a7 = ActiveCell.Value
Cells(8, 25).Select
a8 = ActiveCell.Value
Cells(9, 25).Select
a9 = ActiveCell.Value
Cells(10, 25).Select
a10 = ActiveCell.Value
Cells(11, 25).Select
a11 = ActiveCell.Value
Cells(12, 25).Select
a12 = ActiveCell.Value
Cells(13, 25).Select
a13 = ActiveCell.Value
Cells(14, 25).Select
a14 = ActiveCell.Value
Cells(15, 25).Select
a15 = ActiveCell.Value
Cells(16, 25).Select
a16 = ActiveCell.Value
Cells(17, 25).Select
a17 = ActiveCell.Value
Cells(18, 25).Select
a18 = ActiveCell.Value
Cells(19, 25).Select
a19 = ActiveCell.Value
Cells(20, 25).Select
a20 = ActiveCell.Value
Cells(21, 25).Select
a21 = ActiveCell.Value
Jetzt versuche ich das zu verkürzen, mein ansatzt:
uv = 25
For uz = 1 To 21
rt = uz
Cells(uz, uv).Select
a "rt" = ActiveCell.Value
Geht so aber nicht.
Wer kann mir helfen?
MfG
Karsten
Next uz