Convert Series into Range.

[ayazgreat]

Sorry Kris still unable to upload workbook but tomorrow I will do the same
I am just attaching another sample pic for you kindly see red highlighted last cells I hope you will get what I am I trying to say
In col f and col j the range count should be 1 instead of 3 but code gives me result 3 however it is one

[ayazgreat]

Dear Kris

I am attaching here a sample file, kindly see red highlighted last cells I hope you will get what I am I trying to say
In last cell of col f and col j the range count should be 1 instead of 3 but code gives me result 3 however it is one

[Admin]

Hi,

You haven't pasted the code correctly. Copy the correct code from my post # 6 and try. It should work.

[ayazgreat]

Kris you are right, it works fine now, thank you very much for your kind support