Selecting all of the cells in a Worksheet
:
Return to List
' Handy for setting global formats, and for copying the worksheet in it's entirety.
Cells.Select
See also:
Accessing Particular Cells in Worksheet
Column Number or Letter of selected cell
Convert Column Letter to Number function
Convert Column Number to Letter function
Creating and Sizing Cell Comments
Delete Cell Contents without deleting cell
Determining Last Cells (column & row) with Data
Drop-Down Cell Values (restricting User)
Fill Empty Cells of Selected Area with Data Above Cell
Inserting a Formula into the Active Cell
Moving down one cell (changing active cell)
Moving Right 1 Cell
Pasting (previously copied) Cells
Row number of Selected Cell
Selecting Non-Adjacent Cells in Worksheet
Setting Current Cell's Value
Note to Webmaster