| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro for Selecting Cells within a Range
I am a novice macro writer and need help with the following. Here is a piece
of a macro I recorded: Range("P:P,N:N,L:L,J:J,G:G").Select Selection.NumberFormat = "#,##0.0_);(#,##0.0)" The end result I am shooting for is to change the number format as described above but only for certain cells within the columns I have named in the first line. Can I modify that line to include the names of these cells or is it more complicated than this? Help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting a range of cells in a macro | Excel Discussion (Misc queries) | |||
| macro syntax for selecting variable range | Excel Discussion (Misc queries) | |||
| Selecting a range of cells, how to ? | Excel Worksheet Functions | |||
| Selecting a range of values on pivot table attribute with a macro | Excel Discussion (Misc queries) | |||
| Range selecting cells | Excel Discussion (Misc queries) | |||
Threaded Mode
