Thank you Andy, You assisted when I had almost lost my hopes.
You have given two alternatives, the first one was fine but it would have not fit in my other requirements. Your second alternative really ROCKS!!!
I am new to VBA but learning quickly. I have wrote above code myself, thank you for your assistance in cleaning many unwanted text from code. I have learnt a lot from your code.
Although the following string from your code was responsible to solve my core problem but I coould not understand the code grammer syntax etc.
I would appreciate some more of your effort if you can kindly explain (Just a simple translation into english) what is above code about.
Code = iferror(C1/F4,0)
English = If C1/F4 results in some error, then write Zero.
Thank you again