Hi, Thanks for your input. I have solved the problem. But one more problem has arised. I select a row and it gets highlighted. After this i invoke a Find/Replace function.
When i click Find Next button without entering any data in Find text box, the cell selection toggles in all cells but the background color of the cells is not getting changed as in Excel
How to change that? Kindly reply Thanks [ February 06, 2007: Message edited by: vijaychandran rajagopalan ]
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.