vba_code_3.xlsm‎ is attached in post#1, this is updated where in checking step by step the code was running with msg box displaying 2 ans but at my home system it is giving errors first one being "Invalid qualifier".
Any suggestions or updates are much appreciated.