| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Rows
Alistair,
To answer your original question, No, you can't change the size of a worksheet. However, there is a solution to your problem. Create a dynamic name for your pivot table Data Source using the 'Offset' formula. The formula in your 'Refers To:' field should look something like this... =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),4) where... Sheet1 is the name of the sheet containing the data $A$1 is the top left of your data $A:$A contains no blank cells within the data list and no populated cells outside of the data list Refer to online Help for a full explanation of the OFFSET Worksheet function HTH, Nick. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows from one worksheet automatically, ignore rows that are b | Excel Worksheet Functions | |||
| instering rows in one worksheet that reflect another worksheet | Excel Worksheet Functions | |||
| insert rows in a worksheet that do not change adjoining rows | Excel Discussion (Misc queries) | |||
| How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
| Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95? | Excel Discussion (Misc queries) | |||
Hybrid Mode
