I have a PivotTable *I start every post with that these days*
I have my PivotTables do pretty much everything except make my coffe
(If anyone knows the VB for that let me know :])

Anyway...The PivotTable has records relating to the current month
sales and the datasource is refreshed every day.
What I want is some VB (I figured it could only be done with VB), tha
will look at the range of dates in the Date Field and return the lates
(highest date).

I need this to drop into my worksheet to show when or how far the dat
goes upto.

The second part is to calculate the number of working days that hav
passed.

Anyone?
Gareth

--
Message posted from http://www.ExcelForum.com

Can't you just use the Worksheet MAX function , either in the worksheet or
in code.

--
Regards,
Tom Ogilvy

"GarethG " wrote in message
...
I have a PivotTable *I start every post with that these days*
I have my PivotTables do pretty much everything except make my coffee
(If anyone knows the VB for that let me know :])

Anyway...The PivotTable has records relating to the current months
sales and the datasource is refreshed every day.
What I want is some VB (I figured it could only be done with VB), that
will look at the range of dates in the Date Field and return the latest
(highest date).

I need this to drop into my worksheet to show when or how far the data
goes upto.

The second part is to calculate the number of working days that have
passed.

Anyone?
GarethG


---
Message posted from http://www.ExcelForum.com/