Executes a series of statements making repeated reference to a single object or structure.
Syntax
With object [ statements ] End With
Executes a series of statements making repeated reference to a single object or structure.
Syntax
With object [ statements ] End With
If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.
Continue reading