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