VALUE numerical values that are not formatted as date or timeĭATETIME numerical values that are formatted as date or timeĪNNOTATION comments that are linked to cells This list provides the following elements: The flags specified in clearContents come from the .CellFlags constants list. getCellRangeByName ( "B2:C3" )įlags = com. The following example computes the average value of the A1:C3 range and prints the result in a message box:ĭim Doc As Object Dim Sheet As Object Dim CellRange As Object Dim Flags As LongĬellRange = Sheet. VARP variance based on the total population STDEVP standard deviation based on the total population The following values are available:ĬOUNT total number of all values (including non-numerical values)ĬOUNTNUMS total number of all numerical values The associated constants are defined in the .GeneralFunction enumeration.
The computeFunction expects a constant as the parameter that describes the mathematical function that you want to use. You can use the computeFunction method to perform mathematical operations on cell ranges. For more information and examples of this service, see Formatting Spreadsheet Documents. Just like individual cells, you can apply formatting to cell ranges using the .CellProperties service. GetCellByPosition ( 1, 1 ) Formatting Cell Ranges getCellRangeByName ( "B2:D4" )Ĭell = CellRange. getByName ( "Sheet 1" )ĬellRange = Sheet. Dim Doc As Object Dim Sheet As Object Dim CellRange As Object Dim Cell As Object
0 kommentar(er)
