View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Saariko Saariko is offline
external usenet poster
 
Posts: 1
Default Update PivotTable Range with a button

Hi,

I have a pivottable which it's range is growing constantly. since I don't
know of an automatic way to increase the range of the table, I thaught of
building some kind of a button in VBA to update the range and relying on the
last row that has data.
I usually ad code to my questions, but not this time. I have no idea how to
start it.

I will be happy for help.

Saariko