Oliver1804
New Member
- Joined
- Jan 30, 2020
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
ThisWorkbook.Save
Sheet4.Range("A1").Value = Environ("Username")
Sheet4.Range("B1").Value = Time()
Sheet4.Range("C1").Value = Date
Sheet4.Range("D1").Value = ActiveWorkbook.Name
I'm sorry if this is a stupid question, I'm new to this, how can I get this code to repeat itself. It works but obviously only on the top row.
Thank you for your time
Sheet4.Range("A1").Value = Environ("Username")
Sheet4.Range("B1").Value = Time()
Sheet4.Range("C1").Value = Date
Sheet4.Range("D1").Value = ActiveWorkbook.Name
I'm sorry if this is a stupid question, I'm new to this, how can I get this code to repeat itself. It works but obviously only on the top row.
Thank you for your time