worksheet change event - my code isnt working

**tinkerbelle** · 06-17-2010, 06:12 AM

Hi,

i have a worksheet called "report" and in cell D4 the value is based on the results of a validation list in sheet "selection" cell A5.

When the "report" worksheet is selected i would like it to run a macro similar to my attempt below. So if cell D1 has a value of "version 1" then it will run the line: ActiveSheet.Range("A9:A39").Rows.Hidden = False

Please Login or Register  to view this content.

thanks all.

**StephenR** · 06-17-2010, 06:39 AM

Saying your code isn't working is not terribly helpful. What is not working? What should it be doing that it isn't, or vice versa?

**DonkeyOte** · 06-17-2010, 06:41 AM

If by D4 you mean D1 (as per your code) then the Change event won't fire as and when a formula result updates.

Either

a) switch from Change to Calculate event (though you're then open to the event firing more often than is necessary)

b) apply the Change event against the sheet containing the original Data Validation list (ie the "prime mover")
in turn modify the remaining code such that it is applied to the relevant sheet object rather than the ActiveSheet