Dynamic ranges and offsets

Excel Help for Dynamic Ranges And Offsets in Automating Data Analysis Tasks

Dynamic Ranges And Offsets

Rate this: (3/5 from 1 vote)

	You can loop down a selection using dynamic ranges and cell offset to get the value from the next cell.  For example: VBA Code: Dim curcell As Variant Dim nxtval As Variant  Range("I5").Select Range(ActiveCell, Selection.End(xlDown)).Select For Each curcell in Selection   nxtval = curcell.offset(1,0).value  Next
	Excel Business Forums Administrator
	Posted by Excel Helper on 27 Sep 2007

View Full Post