Okay,

I would like to know if it's possible to have Excel open to a certain
cell depending on the current date? Say, for example, cells C1:C365
contain each date of the year in the MM/DD/YYYY format. I have in
cell A1 the formula to say = "NOW" in the MM/DD/YYYY format.

I would like Excel to open up and be situated on the current date's
cell. So, say if today's date was in cell C200, then I would like
excel top open and be on cell C200.

Is this possible or does it need some basic VB coding?

It needs VB coding (worksheet formulas return values to the cell they are
in, they do not take action such as you want, namely, to move focus to a
cell). Did you want to do that (your post almost hints that you do not)?

--
Rick (MVP - Excel)


"DonkeyKong" wrote in message
...
Okay,

I would like to know if it's possible to have Excel open to a certain
cell depending on the current date? Say, for example, cells C1:C365
contain each date of the year in the MM/DD/YYYY format. I have in
cell A1 the formula to say = "NOW" in the MM/DD/YYYY format.

I would like Excel to open up and be situated on the current date's
cell. So, say if today's date was in cell C200, then I would like
excel top open and be on cell C200.

Is this possible or does it need some basic VB coding?

Hi
If you're willing to click on a cell, try this :
=IF(A1="","",HYPERLINK("#C"&MATCH(A1,C1:C365),"Cur rent Date:")) in a empty cell.
then just click on that cell.
HTH
John
"DonkeyKong" wrote in message
...
Okay,

I would like to know if it's possible to have Excel open to a certain
cell depending on the current date? Say, for example, cells C1:C365
contain each date of the year in the MM/DD/YYYY format. I have in
cell A1 the formula to say = "NOW" in the MM/DD/YYYY format.

I would like Excel to open up and be situated on the current date's
cell. So, say if today's date was in cell C200, then I would like
excel top open and be on cell C200.

Is this possible or does it need some basic VB coding?