Attaching a buttom with an event on VBA
 

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