Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting number format by multiplication - possible bug?
I have problems getting the numberformat right, when offsetting a user input
from a user form to a table. The values are formatted as text, which means that I can't perform math manipulations with the numbers. On the application side, the xl.helpfile recommends multiplying the "troubled area" by 1. this works. The relevant area takes the format from the 1, which is formatted as a number. Trying to record this procedure (rather unelegant I know) and integrate it into VBA doesn't work. Can anybody guide me? Recommendations on how to format the output area or a hint on how I can make the fix described above work are most welcome. Private Sub GemClick_Click() Dim i As Integer Dim dato As Date Dim rg As Range, rgBlank As Range Application.ScreenUpdating = False Worksheets("Timeseddel").Activate Range(Cells(15, 3), Cells(31, 7)).ClearContents Cells(7, 7).ClearContents 'ActiveWorkbook.Save Cells(15, 3).Activate With ActiveCell .Offset(0, 0).Value = LstNavn1.Text .Offset(0, 1).Value = TxtWkType1.Text .Offset(0, 2).Value = TextRmk1.Text .Offset(0, 3).Value = TextTimeDbt1.Text .Offset(0, 4).Value = TextTimeNonDbt1.Text .Offset(1, 0).Value = LstNavn2.Text .Offset(1, 1).Value = TxtWkType2.Text .Offset(1, 2).Value = TextRmk2.Text .Offset(1, 3).Value = TextTimeDbt2.Text .Offset(1, 4).Value = TextTimeNonDbt2.Text .. .. .. Range("J1").Select Selection.Copy Range("F15:G31").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlMultiply, _ SkipBlanks:=True Application.CutCopyMode = False End With End sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number format in regional setting vista not carried in excel2007 | Excel Discussion (Misc queries) | |||
Setting number format for a Chart (bars) from C# | Excel Programming | |||
Setting Cell Number Format With A Worksheet Function | Excel Worksheet Functions | |||
Error setting number format | Excel Programming | |||
Setting number format on range of cells | Excel Programming |