![]() The data is sorted based on the column of the cell that is double-clicked. This example toggles a sort between ascending and descending order when you double-click any cell in the data range. This example sets the font and font size for every cell on Sheet1 to 8-point Arial. Worksheets("Sheet1").Cells(1).ClearContents This example clears the formula in cell one on Sheet1 of the active workbook. This example sets the font size for cell C5 on Sheet1 of the active workbook to 14 points. Using this property without an object qualifier returns a Range object that represents all the cells on the active worksheet. Remarksīecause the default member of Range forwards calls with parameters to the Item property, you can specify the row and column index immediately after the Cells keyword instead of an explicit call to Item. ![]() SyntaxĮxpression A variable that represents a Worksheet object. ![]() ![]() Returns a Range object that represents all the cells on the worksheet (not just the cells that are currently in use). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |