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.

Tags:   Writing VBA | Other    |    VBA macros | Working with ranges

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.

Tags:   Writing VBA | Other    |    VBA macros | Working with ranges

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!

This page has 0 threads Add post