N
neowok
basically trying to put something in worksheet_change so that it aut
updates my pivottable, but ONLY when theres enough data on the sheet t
make the pivottable in the first place, so that when a new blan
version of my workbook is started, the user doesnt get an error fo
every cell they change.
If (Not (IsEmpty(Cells(a4)) = "" Or IsEmpty(Cells(a5)) = "")) The
Worksheets("Planned+Actual men char
data").PivotTables(1).RefreshTable
thats the code im trying to use but its producing an "applicatio
defined or object defined error" whenever i change a cell. cells A
and A5 are the first rows of my data table which would go into th
pivottable, and the pivottable will work ok if heres 2 rows of data t
base the table and pivotchart on, so if these 2 cells are not empty, i
theory someone has filled them in and the chart can now be created.
thats if i can make this code wor
updates my pivottable, but ONLY when theres enough data on the sheet t
make the pivottable in the first place, so that when a new blan
version of my workbook is started, the user doesnt get an error fo
every cell they change.
If (Not (IsEmpty(Cells(a4)) = "" Or IsEmpty(Cells(a5)) = "")) The
Worksheets("Planned+Actual men char
data").PivotTables(1).RefreshTable
thats the code im trying to use but its producing an "applicatio
defined or object defined error" whenever i change a cell. cells A
and A5 are the first rows of my data table which would go into th
pivottable, and the pivottable will work ok if heres 2 rows of data t
base the table and pivotchart on, so if these 2 cells are not empty, i
theory someone has filled them in and the chart can now be created.
thats if i can make this code wor