| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mulit-column number formatting
I'm trying to format a sequence of columns, but without success. I've used:
Sub x() Dim i As Integer, iCol As Integer For i = 1 To 47 iCol = 12 + 7 * (i - 1) Range(Cells(, iCol), Cells(, iCol + 2)).NumberFormat = "0.00" Next i End Sub I've tried columns(icol, icol+2) as well. Any ideas? TIA, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Which version of Office does support mulit-processors? | Excel Discussion (Misc queries) | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| How do I set up a transport cost with mulit origins, destin,svcs | Excel Worksheet Functions | |||
| Mulit Users in a shared protected workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
