Just some added INFO.
this assumes you don't want to start your dates in cell A1 like you stated.

--
Regards,
Tom Ogilvy

"Don Guillett" wrote in message
...
right click the excel x just to the left of FILE on the menucopy/paste
thissave. Now, each time the file is opened excel will check the last
cell
in col A of sheet 10. Modify to suit.

Private Sub Workbook_Open()
Set x = Sheets("sheet10").Cells(Rows.Count, "a").End(xlUp).Offset(1)
If x.Offset(-1) < Date Then x.Value = Date
End Sub

--
Don Guillett
SalesAid Software

"cappuccine"
wrote
in message ...

I posted this in the new users forum but figured it would probably best
be answered here.

I am trying to design a macro to work with a database I made in excel.
I have a lot of questions since I have never made a macro before. But
I'll just start with a simple question. I want to run a macro that will
input the current date in cell a1, then when I run the macro the next
day, I want to input the current date in cell a2. How do I set up a
macro to do that? I tried setting up a counter but I don't know how to
say something like Range(a1 + 1) = Now. So it selects the next cell
down everytime I run it. Thanks for the help in advance.

Jason


--
cappuccine
------------------------------------------------------------------------
cappuccine's Profile:
http://www.excelforum.com/member.php...o&userid=28242
View this thread:
http://www.excelforum.com/showthread...hreadid=482006

a1 is named DATES

--
Don Guillett
SalesAid Software

"Tom Ogilvy" wrote in message
...
Just some added INFO.
this assumes you don't want to start your dates in cell A1 like you
stated.

--
Regards,
Tom Ogilvy

"Don Guillett" wrote in message
...
right click the excel x just to the left of FILE on the menucopy/paste
thissave. Now, each time the file is opened excel will check the last
cell
in col A of sheet 10. Modify to suit.

Private Sub Workbook_Open()
Set x = Sheets("sheet10").Cells(Rows.Count, "a").End(xlUp).Offset(1)
If x.Offset(-1) < Date Then x.Value = Date
End Sub

--
Don Guillett
SalesAid Software

"cappuccine"
wrote
in message
...

I posted this in the new users forum but figured it would probably
best
be answered here.

I am trying to design a macro to work with a database I made in excel.
I have a lot of questions since I have never made a macro before. But
I'll just start with a simple question. I want to run a macro that
will
input the current date in cell a1, then when I run the macro the next
day, I want to input the current date in cell a2. How do I set up a
macro to do that? I tried setting up a counter but I don't know how to
say something like Range(a1 + 1) = Now. So it selects the next cell
down everytime I run it. Thanks for the help in advance.

Jason


--
cappuccine

------------------------------------------------------------------------
cappuccine's Profile:
http://www.excelforum.com/member.php...o&userid=28242
View this thread:
http://www.excelforum.com/showthread...hreadid=482006

You must be answering in the wrong thread.

Either that or your trying to jerk us all around <g

--
Regards,
Tom Ogilvy


"Don Guillett" wrote in message
...
a1 is named DATES

--
Don Guillett
SalesAid Software

"Tom Ogilvy" wrote in message
...
Just some added INFO.
this assumes you don't want to start your dates in cell A1 like you
stated.

--
Regards,
Tom Ogilvy

"Don Guillett" wrote in message
...
right click the excel x just to the left of FILE on the
menucopy/paste
thissave. Now, each time the file is opened excel will check the last
cell
in col A of sheet 10. Modify to suit.

Private Sub Workbook_Open()
Set x = Sheets("sheet10").Cells(Rows.Count, "a").End(xlUp).Offset(1)
If x.Offset(-1) < Date Then x.Value = Date
End Sub

--
Don Guillett
SalesAid Software

"cappuccine"
wrote
in message
...

I posted this in the new users forum but figured it would probably
best
be answered here.

I am trying to design a macro to work with a database I made in
excel.
I have a lot of questions since I have never made a macro before.
But
I'll just start with a simple question. I want to run a macro that
will
input the current date in cell a1, then when I run the macro the
next
day, I want to input the current date in cell a2. How do I set up a
macro to do that? I tried setting up a counter but I don't know how
to
say something like Range(a1 + 1) = Now. So it selects the next cell
down everytime I run it. Thanks for the help in advance.

Jason


--
cappuccine

------------------------------------------------------------------------
cappuccine's Profile:
http://www.excelforum.com/member.php...o&userid=28242
View this thread:
http://www.excelforum.com/showthread...hreadid=482006