Category: Excel VBA

Visual Basic for Applications (VBA) is a programming language used to automate certain tasks that would normally take up a lot of time. A few of the things you can do with Excel VBA include manipulating cells, formatting sheets and ranges, changing font type and color, copying and pasting cells or ranges of cells, compositing sheets into one sheet or converting sheets from horizontal to vertical orientation.

You can also automate processes such as printing worksheets, adding new sheets on the fly, or even formatting an entire workbook with a single VBA command.