VBA in Excel to select a cell on other tab
Trying to update multi PivotTables by changing the date on another sheet. I开发者_StackOverflow can do this if I use a range on the same sheet by using
ActiveSheet.PivotTables("PVT1").PivotFields("Month").CurrentPage = _
"11/1/2010"
and change it to
ActiveSheet.PivotTables("PVT1").PivotFields("Month").CurrentPage = _
Range("C1").Text
but I can not get the right string to add to the range for Sheets("Sheet2").Range("C1").Text
Just DIM's the location and called it from there. It worked so I'm happy. Thanks for looking
精彩评论