- Jul 11, 2011
Can I use named ranges to trigger actions using the Worksheet Change event? I'm having trouble discovering the correct syntax. I tried Target.Range and Target.Name and Target.Address but those didn't work for me. I have several different cells & actions, so something with a SELECT / CASE structure could be really slick. Any ideas?