One final question. For Sub UnwindChart, there is more to the If statement than just the target cell being F26. Cell G7 also needs to be anything except blank or "Unprinted". Would it be better to add it to the Worksheet_Change sub...
...or to the UnwindChart sub?ElseIf ActiveCell.Address(0, 0) = "F26" Then
If rngTarget.Value = "Roll" Or rngTarget.Value = "Roll_Stock" ThenI tried adding the additional criteria to the existing code, but nothing worked. Got a little more magic?
Thanks.