I have a workbook for each month. In each workbook are sheets for each day, such as April 1, 2007. This data is in cell A1. What I would like to do is put the date for each sheet in A1. So that the sheet for April 1st has April 1, 2007 in A1, on the sheet for April 2, 2007 the date in A1 will be April 2, 2007. Is there a way to do this for each sheet without manually typing it into cell A1 on each sheet? Thanks, Larry Sometimes I think I understand everything, then I regain consciousness

Are you creating each sheet on that particular date (one one each day?) Life is more painless for those who are brainless.

Yes, there are tabs across the bottom that have each date on them. And the workbook itself is the month. Like June will have a workbook with 30 sheets across the bottom, each with the date on them. (I used ASAP utilities for this.) Then in cell A1 I need to have the date of the sheet. I did Feb by hand, going to each sheet and changing the cell A1 to the proper date. Trying to avoid doing this for the rest of the year. Larry Sometimes I think I understand everything, then I regain consciousness

CTRL; Will insert the current date. You can format the cell as you wish. Life is more painless for those who are brainless.

Thought about just using the Date function, but the people I'm trying to help are being grumpy and want each sheet to have the date on it in advance. Why? I don't really know. But hey, you get stuck with these jobs sometimes. TIA, Larry Sometimes I think I understand everything, then I regain consciousness

http://www.ozgrid.com/VBA/return-sh... The page may offer what you seek. Bryan

Perfect, Bryco. Thanks. And thanks to Jennifer also. Really appreciate it. Larry Sometimes I think I understand everything, then I regain consciousness