Thread
:
Macro to update pivot table data range
View Single Post
#
2
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 29
Macro to update pivot table data range
Taffy,
I think the issue is in the "SourceData" argument. If you change it to:
SourceData:="Sales!" & Worksheets("Sales").Range("A5").CurrentRegion.Addr ess
it should work.
Hope this helps,
Ben
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]
Macro to update pivot table data range