Hello,
I'm new here and new to VBA/Programming in general, so forgive me if this question is stupid.....
Basically, I need some advice on how to write the code below with a loop? It does exactly what I need it to do as it is, but it looks clumsy I guess and I'd like to get a basic understanding of loops etc. I've googled a few examples but so far they've flew over my head... I think with something related to what I'm doing will help me understand the terms/theory etc. better.
Thanks in advance for any help
ActiveCell.Value = (Date - 1)
'ActiveCell.Offset(1, 0).Select
'ActiveCell.Value = Date
'ActiveCell.Offset(1, 0).Select
'ActiveCell.Value = (Date + 1)
'ActiveCell.Offset(1, 0).Select
'ActiveCell.Value = (Date + 2)
'ActiveCell.Offset(1, 0).Select
'ActiveCell.Value = (Date + 3)
'ActiveCell.Offset(1, 0).Select
'ActiveCell.Value = (Date + 4)
'ActiveCell.Offset(1, 0).Select
'ActiveCell.Value = (Date + 5)
'ActiveCell.Offset(1, 0).Select
Bookmarks