Use the MAX function on your dates, you dont need to do in VBA, but you can.

"Scott Halper" wrote:

I have a bunch of columns (below). I want to write the VBA to search
all the date columns and then display the most recent date in another
column.

Columns:

Firm Name Date 1 Meeting Type Date 2 Meeting Type Date 3 Meeting
Type Date of Last meeting
XYZ Smith 1/1/91 Lunch 2/1/01 Dinner
3/1/08 Conference 3/1/08
ABC Joe 12/31/07 Call 1/15/08 Lunch
2/29/08 Dinner 2/29/08

Thanks for your help.

Scott