Excel 2007 : Macro return First and Last dates in visible cells

Hi,

Is there any macro that can return the first and the last dates from visible cells within a date formated column in a data sheet to the nominated cells in the report sheet?

For example after filtering say by a customer name the dates of transactions are as follows (in the data sheet):

1/08/2010
6/08/2010
17/08/2010

In the Report worksheet Say Column A Row 5 is "From: and Column B Row 5 is blank to insert the first date of the customers from the visible cell (Eg. 1/08/2010) and Column C Row 5 is "To" with Column D Row 5 is blank to receive the last visible date (Eg. 17/08/2010)

Appreciate any help. I use Excel 2007

Thank you,

Yogi

Hi, Try this:-
Dates assumed to be in Column "A".

Please Login or Register  to view this content.

Regards Mick

Thank you Jerry for your prompt response. Much appreciated.

Regards,

Yogi

G'day Mick,

Thank you for the suggested macro. Appreciate your prompt response too.

Regards,

Yogi