Datum generieren (VBA)

Martin Asal @, Donnerstag, 15. Februar 2018, 15:03 (vor 127 Tagen) @ moonlink

ungefähr so:

Public Sub Werktage()
Dim t As Worksheet
Dim d As Date
 
d = Date
 
For Each t In ActiveWorkbook.Sheets
    d = d + 1
    t.Range("B2").Value = d
Next
 
End Sub


Martin


gesamter Thread:

 RSS-Feed dieser Diskussion

powered by my little forum