Posted to microsoft.public.excel.programming

Saariko

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivottable update Excel 2007	Mikmac	Excel Discussion (Misc queries)	0	August 19th 09 02:17 PM
PivotTable Field Value List Update	Hutch	Excel Discussion (Misc queries)	0	August 1st 08 04:46 AM
Update PivotTable	[email protected]	Excel Worksheet Functions	4	September 18th 06 10:23 PM
Dynamic parameterized PivotTable update?	Nick Keller	Excel Discussion (Misc queries)	0	February 24th 06 11:02 PM
Update Chart in Pivottable	Tobias[_2_]	Excel Programming	1	April 27th 04 12:56 PM

All times are GMT +1. The time now is 04:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us