Sorry, move down in the sense that the contents of A2:B2 would copy or move
to A32:B32 for example but not insert rows. Thanks.
--
David P.


"Don Guillett" wrote:

Yes, at the start, put the date in a1..
I understood "move down the column" to insert rows.

What, EXACTLY to you want?

--
Don Guillett
SalesAid Software

"David P." wrote in message
...
Do I put today's date in A1?
What cell would this example referencing to copy and / or move?
My other question is, this macro won't be inserting rows will it?
Thank you for your assistance.

David P.


"Don Guillett" wrote:

try this idea to check the date in a1 and insert days required to bring
up
to date & change date stored in a1

Sub insert30rows()
If Date < Range("a1") Then
x = (Date - Range("a1")) * 30
Rows("9:" & 8 + x).Insert
Range("a1") = Date
End If
End Sub

--
Don Guillett
SalesAid Software

"David P." wrote in message
...
I need for a range to move down the column 30 cells automatically at the
beginning of every day. Is that possible?
--
David P.