Hi all,

I have a button which I can move and place on my sheet.

I need it to delete the 7 cells adjacent TO THE LEFT of it's position.

I have tried a few google methods but most seems to act on the right of the button, and one had OFFSET used which confused me no end.

Can anyone offer a suggestion - just need to assign a macro to the button to clear contents of 7 cells to left.

Thanks,

Ian