Want a formula or a macro
Hello Vishesh,
As per your instructions I have placed your code in to my sheet 1 , but when I run the macro I get compile error, I have attached the same file in which I pasted your code please try your self by running the macro and suggest what to do next...
Thanks
| Attachment | Size |
|---|---|
| ex.xls | 14.5 KB |

Solved
for solution chk this
http://excelexperts.com/node/1114
I have provided a button on the sheet; click on it and see the results