| VBA / Excel / Access / Word » Excel » Cell |
| 1. | Is a cell empty | ||
| 2. | Get the last cell | ||
| 3. | Magic Squares | ||
| 4. | Nest If statement in Do Loop While with comparison operators | ||
| 5. | Nest If statement in Do Loop Until for cells | ||
| 6. | Is active cell empty | ||
| 7. | Transposing is taking a rectangular block of data and rotating it so that columns become rows and vice versa. | ||
| 8. | Uses nested For/Next loops to count the total number of cells used in all open worksheets: | ||
| 9. | Selects cell G4 | ||
| 10. | A better way to write to a range:Filling a range | ||
| 11. | Use arrays to fill ranges faster | ||
| 12. | Moving the pointer to the cell containing the greatest value |