I've a Worksheet_Change function based on some drop down box changed as follow:
Let say I have 100 drop down box, e.g. from "$F$1" to "$F$100"![]()
Please Login or Register to view this content.
I tried to create a string that can replace the long target address (e.g. "$F$1", "$F$2", "$F$3",....)
I've create a code as follow:
and replace as target address as follow:![]()
Please Login or Register to view this content.
but not working... I'm not sure this method working or not so I'm trying to work on this.![]()
Please Login or Register to view this content.
Could somebody help me on this...
Thanks!
Bookmarks