try this
Sub replaceyearindate()
Columns("e").Replace "2009", "2008"
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jack B" wrote in message
...
Re Ofc Pro 97 --

I re-worked part of a check book for 2008.

Now I realize that my dates which show up in the column, for instance,
like
4/23, actually have a 2009 date (4/23/2009) instead of a 2008 date.

How do I get the entire column to reflect 2008 dates?


Jack