Run-time error 1004 in Excel when running macro
If when you select a range of cells on an Excel worksheet and try to run a macro, you get an error message like this one:
. . . the problem may stem from the data on the worksheet being formatted as a Table. In order to solve in this problem, select any range on the worksheet. Then right click and go to Table . . . Convert to Range. You should then be able to run the macro successfully.