See if this helps...
http://vbaexpress.com/kb/getarticle.php?kb_id=600
Look for this comment in the code:
'Define the list and where it's obtained from (Columns A, D, G in this example)
See if this helps...
http://vbaexpress.com/kb/getarticle.php?kb_id=600
Look for this comment in the code:
'Define the list and where it's obtained from (Columns A, D, G in this example)
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln