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