| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell justifcation
Below is a snippet of code which puts a : in a number in the cell and
it works great. My problem is that when it does this it changes the cell justification from Centered to Left justifed. Any way around this? If Target.Count=1 And Not Application.Intersect(_ Me.Range("E3:G87"), Target) Is Nothing Then Application.EnableEvents=False If IsNumeric(Target.Value) And InStr(Target.Value, ":")=0_ And Len(Target.Value) <5 Then Target.Value=Format$(Target.Value, "00\:00") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| Macro to export data to fixed width not saving right justifcation | Excel Programming | |||
| NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Threaded Mode
