Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following VBScript function to set the NumberFormat on a Range.
It appears instead to be setting the NumberFormat for all cells in the Sheet. Can anyone explain what I'm doing wrong? (Using Excell 2002) Private Sub setCellRangeNumberFormat (intBeginRow, intBeginColumn, intEndRow, intEndColumn, strNumberFormat) m_objExcelApp.Range ( _ m_objExcelApp.Cells(intBeginRow, intBeginColumn), _ m_objExcelApp.Cells(intEndRow, intEndColumn) _ ).Style.NumberFormat = strNumberFormat End Sub Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
number format in regional setting vista not carried in excel2007 | Excel Discussion (Misc queries) | |||
'conditional format' cells for the highest number in a range | Excel Discussion (Misc queries) | |||
Setting Cell Number Format With A Worksheet Function | Excel Worksheet Functions | |||
how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
Setting range of cells format to currency | Excel Programming |