try this see if it helps
Sub Pivot_table()
Dim ptitm As PivotItem
Dim dt As Date
dt =
DateSerial(Year(Application.WorksheetFunction.Max(Sheet1.Range("c:c"))),
Month(Application.WorksheetFunction.Max(Sheet1.Range("c:c"))),
Day(Application.WorksheetFunction.Max(Sheet1.Range("c:c"
Application.
Hi shish ji,
Could you make a changes in attached file.
On Sun, Jul 28, 2013 at 10:10 AM, ashish koul wrote:
> r u trying to choose maximum date in report filter if so then you have to
> apply filter
>
>
> On Sun, Jul 28, 2013 at 9:17 AM, Sanjay Kumar Maurya <
> mail2sanja...@gmail.com> wrote
r u trying to choose maximum date in report filter if so then you have to
apply filter
On Sun, Jul 28, 2013 at 9:17 AM, Sanjay Kumar Maurya <
mail2sanja...@gmail.com> wrote:
> Hi Vabz
>
> PFA dummy data file.
>
> On Saturday, 27 July 2013 21:59:18 UTC+5:30, Sanjay Kumar Maurya wrote:
>>
>> Hi Al
