| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to change number format of a highlighted range in Excel 2007
I was using the following macro to change the number format of a highlighted
range. Selection.NumberFormat = "#,##0" In Excel 97 and 2000 it was working fine. In Excel 2007 it is giving me the following error message: Run-time error '1004' Unable to set the NumberProperty of the range class I am stumped and haven't been able to find any documentation on this change. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you change the default number format in Excel 2007? | Excel Discussion (Misc queries) | |||
| How do I change background color of highlighted Excel range ? | Excel Discussion (Misc queries) | |||
| Excel 2007 Record Macro button in Developer tab is not highlighted | Excel Discussion (Misc queries) | |||
| *.csv format change if .xlt save as .csv in Excel 2007 | Excel Discussion (Misc queries) | |||
| How to count the number of cells highlighted using Conditional Formatting feature present in Format Menu of Excel??? | Excel Programming | |||
Threaded Mode
