| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
|
|||
|
|||
Cell right next to colored cells is automatically colored on entering a value
one way:
Range("A1").NumberFormat = "@" In article , "Johan De Schutter" <jdsATDOTnisusDOTbe wrote: 2) How do I change the formatting of a cel by VBA-code? For example: change from General to Text |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - cell borders not visible when cells colored | Excel Discussion (Misc queries) | |||
| VBA to count colored cells | Excel Worksheet Functions | |||
| colored cells | Excel Discussion (Misc queries) | |||
| Colored and filtered cells | New Users to Excel | |||
| sum colored cells | Excel Discussion (Misc queries) | |||
Threaded Mode
