gegeben seien Variable VAR und ZEI
Wie schreibe ich
den Wert von VAR in Zelle A der Zeile ZEI ...
Sub schw()
Const strTEXT As String = "Hallo"
Const ZEI As Long = 5
Cells(ZEI, 1).Value = strTEXT
Range("A" & ZEI + 10) = strTEXT & "2"
Rows(ZEI + 15).Cells(1)= strTEXT & "3"
End Sub
Sub schw()
Const strTEXT As String = "Hallo"
Const ZEI As Long = 5
Cells(ZEI, 1).Value = strTEXT
Range("A" & ZEI + 10) = strTEXT & "2"
Rows(ZEI + 15).Cells(1)= strTEXT & "3"
End Sub
cells(zei,1)=var
, wenn a Spalte 1 sein soll