"Ref_2" Argument Is Not Optional with CREATE.OBJECT Command

SUMMARY

Page 40 of the "Microsoft Excel Function Reference" incorrectly indicates that the fifth argument ("ref_2") to the CREATE.OBJECT command is optional if you are creating a picture. However, you will encounter a macro error if you omit this argument.

MORE INFORMATION

The CREATE.OBJECT command is used in a macro to draw a graphic object on a sheet. The arguments used indicate the type and location of the object. Type 8 is used to create a picture (normally created by the camera tool). The "Microsoft Excel Function Reference" incorrectly states that the fifth argument ("Ref_2") is optional when creating a picture object.

"Ref_2" indicates in which cell the lower right corner of the object will be. If this argument is omitted, you will receive a macro error when the macro is run. Including this argument will eliminate the macro error, yet has no effect on the placement of the picture created.

REFERENCES

"Microsoft Excel Function Reference." Version 3.00, pages 40-41.