Command button

[nicolaforni]

Hi I created a macro where I highlight some cells in Sheet1 and then go back to Sheet2.

Please Login or Register  to view this content.

This macro works fine but when I put it inside a Command Button (see below) I get an error message saying "Run-time error'1004': Select method of Range class failed"

Please Login or Register  to view this content.

How should code inside Command Button look so that it works?

Thanks,
Nix

[StephenR]

What do your other macros do?

[tozjerimiah]

Why not go into the developer tab, click Insert, click the Button and assign the macro? Quick & dirty fix!!

[nicolaforni]

There is only one macro which is highlight one.

Quick and dirty fix works.

Nix

[romperstomper]

Please Login or Register  to view this content.