just add the button, and while its in design mode, right click and choose view code, then add your code between the two lines generated for you.

----- Ranjan as usual wrote: ----

Dear folks
I want to add a button to my excel sheet, which when clicked runs the code that I wrote under the VBA editor. How do I link this button to the code, so the event fires? My code simply clears the empty rows. Any pointers will be appreciated

cheers

Ranjan