Hello again,
I'm having a slight problem selecting a range based on an integer value.
I have a counter that increments as long as the cells in H are empty (starts at 3 as the first two are headers)
What I have so far is
It keeps crashing on the last line though. Any help would be much appreciated, thanks!i = 3
temp = True
Do
If LCase(Range("H" & i).Value) = "end" Then temp = False
i = i + 1
Loop While (temp)
Columns("H3:H" & i).Select
Edit : Nevermind! Just took me rewriting it on here to catch it.. thanks =)
Bookmarks