Please find the attached file.I have tried this code more than 50 times, now it is working correctly, thing you should note that this attachment contains a sheet rough which need to be there if you wish You can remove that after doing your work.
This code will highlight cell in yellow which is formatted in currency format, if that suits your need, comment this line after checking
y.Interior.Color = vbYellow so that it will not mark yellow color on formatted cells.(Yellow color is just for check for right cells done)
Bookmarks