BY TOPIC▼
EXCEL / VBA BLOGS▼
VBA MACROS BLOGS▼
- Recording macros (1)
- Working with ranges (4)
- Input/message boxes (3)
- Variables, arrays (3)
- Enumerations (2)
- Loops and conditions (2)
- Errors and debugging (2)
- Functions / arguments (3)
- Events (2)
- User forms (6)
- Classes (4)
- References (9)
- Files and folders (4)
- General (17)
- Working with charts (4)
- Flappy Owl (14)
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on Working with ranges in VBA macros
Showing blogs 1-4 (out of 4)
How to get Excel to read out cell values on calculation
Posted by Andy Brown on 26 September 2016
A short blog explaining how you can get Excel to read out values in cells every time that you recalculate a worksheet.
Referring to a range using square brackets
Posted by Andy Brown on 17 December 2015
This short blog shows that there is a third way to refer to a range, other than using the RANGE or CELLS keywords.
Relative Selection using Excel VBA Macros
Posted by Andy Brown on 16 August 2011
This blog shows the various techniques within Excel Visual Basic for moving around and selecting cells relative to the active cell or selection. The blog includes a discussion of the Offset, End, Resize, Range, EntireRow, EntireColumn and CurrentRegion methods.
Selecting Cells using Excel VBA Macros - Absolute
Posted by Andy Brown on 11 August 2011
This blog gives the various possible ways to select cells, ranges, columns and rows using Visual Basic for Applications in Excel. Useful for the VBA newbie, but even gurus might find one or two commands they'd missed!