Test for range first

Excel Help for Test For Range First in Developing and Auditing Analytical Models

Test For Range First

Rate this: (3/5 from 1 vote)

	One way to test for the range is to first check if there is only one cell. VBA Code: Range("B1").Select If ActiveCell.Offset(1, 0) <> "" Then        Range(Selection, Selection.End(xlDown)).Select End If For Each word In Selection   'original code here Next
	Excel Business Forums Administrator
	Posted by Excel Helper on 15 May 2007

View Full Post