Printable View
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
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
Hi,
You haven't pasted the code correctly. Copy the correct code from my post # 6 and try. It should work.
Kris you are right, it works fine now, thank you very much for your kind support