Thread: Quickie... How to change a name with a macro?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pauloreiss[_5_] pauloreiss[_5_] is offline
external usenet poster
  
Posts: 1
Default Quickie... How to change a name with a macro?

I have the following object:
-ActiveSheet.PivotTables("Table Number 5").PivotCache.Refresh-

I would like to change the name of this PivotTable.

But the macro will do this in many different files with different
PivotTable names, and i want them all to be the same!

There is only one pivottable for each file. The would open the file,
activate the table in that sheet and change it to the standart name.

Somebody help, plz!


--
pauloreiss
------------------------------------------------------------------------
pauloreiss's Profile: http://www.excelforum.com/member.php...o&userid=29820
View this thread: http://www.excelforum.com/showthread...hreadid=498673

Reply With QuoteReply With Quote