Hi, I have a pivot table on a spreadsheet, with the selection section i
cells B6:B11 (eg: the parameters you can change to alter the data pulle
back by the pivot table).
Whenever B9, B10 or B11 are changed I want a worksheet_change to fire.
I know how to do it when it is changing to a specific target, but thi
time I just want it to change if the content of the cell is changed.
Is that possible, if so, any help gratefully received.
Amy x

--
AmyTaylo
-----------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...fo&userid=2097
View this thread: http://www.excelforum.com/showthread.php?threadid=53061