I still get "select method of range class failed" and highlights the following

Range("E:E,G:G,H:H,I:I,J:J,F24:F26").Select

"papou" wrote:

Hello Gary
If you are running code from a commandbutton from the Controls tool box then
consider setting the TakeFocusOnClick property to false.

HTH
Cordially
Pascal

"Gary" a écrit dans le message de news:
...
I have written a macro to change the currency format of certain cells on a
number of different sheets in one workbook. It works when i run it
through
tools/macros/ run, but goes into error when i try and run it from a click
button, any ideas