Simplify built-in functions - When using certain functions frequently, reassign them to a user-defined function. Do this judiciously, as VBA takes up a lot of characters to define a `Function`. The example below would actually be larger with one (or more) fewer `Format()` calls. The following code (**127** chars) can be reduced from: <!-- language-all: lang-vb --> Sub q() w = 0 x = 1 y = 2 z = 3 a = Format(w, "0.0%") b = Format(x, "0.0%") c = Format(y, "0.0%") d = Format(z, "0.0%") End Sub to (**118** chars): Sub q() x = 1 y = 2 z = 3 a = f(w) b = f(x) c = f(y) d = f(z) End Sub Function f(g) f = Format(g, "0.0%") End Function