Home > Forum Home > Developing and Auditing Analytical Models > Concatenate two columns? > Test for range first Share

Test for range first

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


Forum TopicLogin

Test For Range First

Rate this:
(3/5 from 1 vote)
HappyOne 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 on
 
View Full Post

Find relevant Excel templates and add-ins for Test for range first in the

© Business Spreadsheets   Legal   Follow us: