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

Amy

The Worksheet_Change event will fire when *any* cell on the sheet is
changed. You can put an if statement in the event code to prevent the code
from running except when it's one of those cells.

If Not Intersect(Target, Me.Range("B9, B10, B11")) Is Nothing Then
'Your code here
End If

--
Dick Kusleika
MS MVP - Excel
www.dailydoseofexcel.com

AmyTaylor wrote:
Hi, I have a pivot table on a spreadsheet, with the selection section
in cells B6:B11 (eg: the parameters you can change to alter the data
pulled 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 this
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 xx

Hi Dick, thank you sooo much !
Amy xx


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=530615