Run-time error 1004 in Excel when running macro
- Sean O'Shea
- Aug 10, 2017
- 1 min read
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.
