Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
increase range programmatically
hi,
I have a pivot table which is based on a specified range from another sheet in the same workbook. All works fine if there are no records within the specified range, but when there are records added resulting in new records being outside of the specified range, we start to have problems. I DO NOT want to specify the WHOLE sheet as the range, as this will slow down the file and increase it's size. Does anyone know how to programmatically increase the defined range when new records are entered? Thanks in advance geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
increase range programmatically
Probably the easiest is to use a dynamic named range. Check out this link
(about half way down) http://www.cpearson.com/excel/named.htm -- HTH... Jim Thomlinson "geebee" wrote: hi, I have a pivot table which is based on a specified range from another sheet in the same workbook. All works fine if there are no records within the specified range, but when there are records added resulting in new records being outside of the specified range, we start to have problems. I DO NOT want to specify the WHOLE sheet as the range, as this will slow down the file and increase it's size. Does anyone know how to programmatically increase the defined range when new records are entered? Thanks in advance geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trying to programmatically change chart data range with vb.net | Charts and Charting in Excel | |||
Programmatically defining dynamic range | Excel Programming | |||
How do I programmatically specify a range. | Excel Programming | |||
Programmatically increase the row # in a formula | Excel Programming | |||
How to Programmatically Insert a Page Break Every Nth Row in a Range | Excel Programming |