How to handle Excel runtime error 1004

Excel runtime error 1004 bothering you? PHP editor Xinyi summarizes the solutions and provides you with a clear and easy-to-understand guide. Hurry up and read the details below to solve this annoying problem once and for all!

Open Excel and click File in the upper left corner.

Select the options in the pop-up window.

Click Trust Center.

Click Trust Center Settings.

Click Macro Settings.

Click to check Trust access to the VBA project object model, and then click OK to solve this problem.

B$1, for the column label [B" relative reference, when copying the formula, it will become the corresponding other column label. And $1 represents an absolute reference, unchanged in the copied formula

$A1, for column label A, is an absolute reference, $ means an absolute reference, which does not change when the formula is copied; and 1 is a relative reference, which changes when the formula is copied.

The above is the detailed content of How to handle Excel runtime error 1004. For more information, please follow other related articles on the PHP Chinese website!