listi.net

Formatting Routines

Most of the formatting you do in VBA is via the Macro recorder.

Formatting is some of the messiest code you will have.

Record a macro and set the formatting to columns H and I to #,

0.

You'll get the following



   Columns("H:I").NumberFormat = "#,

0"

The # is a number that will hide if a 0.

So for example

Another way is via the Format command.

ASP

Doesn't support Format