how to add range in this vba code

[prasadk]

Thank you very much georgiboy
i have tested your code it's working perfectly