Create a new workbook. Write a trivial macro like:
Create second new workbook. Do "Record Macro", putting it in Workbook2. Use the mouse to run the first macro. Stop recording. The recorded macro and will show you the proper syntax.Sub test() MsgBox "one" End Sub
Recording a macro is one of the easy way to find the syntax for some proceedures.
Bookmarks