![]() Null if all the cells don't have the same format Set/Get the number format associated with the cells in the range. Set/Get the Name object that contains the name for the range Set/Get whether the current range contains merged cells Returns a range containing the merged range of the current cell range Returns the MDX (Multidimensional Expression) that can be sent to an OLAP provider Returns Null if only some of the cells in the range are locked Set/Get whether cells in the range can be modified if the sheet is protected. Returns the location of the upper-left corner of the range Returns the number of header rows in the range Returns the distance from the left edge of the leftmost column in the range to the left edge of ColumnA Returns an object containing options to format the inside area of the range, if applicable (for example, interior color) Set/Get the ID used for the range if the worksheet is saved as a web page Returns the collection of hyperlinks in the range Set/Get how the cells in the range are horizontally aligned. Only works if the range contains whole columns or rows Set/Get whether the cells in the range are hidden. If only some of the cells contain formulas, then Null is returned Returns whether all the cells in the range contain formulas (True). Returns whether a single cell range is part of an array formula Set/Get the formula of the range in the language of the user using the R1C1 style references ![]() Set/Get the formula of the range in the language of the macro using the R1C1 style references Set/Get the formula of the range in the language of the user using the A1 style references Set/Get whether the formula will be hidden if the workbook/worksheet is protected Set/Get the array formula of the cells in the range Set/Get the formula of the cells in the range Returns an object holding conditional formatting options for the current range Returns an object containing Font options for the text in the range Returns the Errors collection associated with the Range object Returns the full worksheet row(s) occupied by the current range Returns the full worksheet column(s) occupied by the current range Which end of the region is specified by the Direction parameter Returns the cell at end of the region containing the Range object. ![]() Returns the direct precedents of a cell on the same sheet as the range Returns the direct dependents of a cell on the same sheet as the range Returns the dependents of a cell on the same sheet as the range A region is defined as an area that is surrounded by blank cells Returns the current region that contains the Range object. Returns a Range object that represents the array associated with the particular cell range, if the cell is part of an array Counts the largest value in a given range of values Returns the number of cells in the current range Returns an object representing the range comment, if any Returns Null if the columns in the range have different widths Set/Get the column width of all the columns in the range. Returns a range of the columns in the current range Returns the column number of the first column in the range Returns all the characters in the current range, if applicable The Cells property will return the same range as the current range Each border side can be accessed individually in the collection Returns all the individual borders around the range. Returns an object containing the different noncontiguous ranges in the current range Returns True if the range can be edited on a protected worksheet The type of address (reference, absolute, A1 reference style, R1C1 reference style) is specified by the parameters Returns the address of the current range as a string in the user's language. Parameters: RowAbsolute, ColumnAbsolute, ReferenceStyle As XlReferenceStyle. Returns the address of the current range as a string in the macro's language. Set/Get whether text in a cell is automatically indented if the text alignment in a cell is set to equally distribute
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |