Jack wrote:
However I wish to do this by attaching code to the click event of a button rather than a macro,
using the code from the Macro in the click event will bring up a runtime error 1004
'Select method of range class failed',


Set the TakeFocusOnClick property of the button to False


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup