+ Reply to Thread
Results 1 to 1 of 1

Selecting Range based on integer

  1. #1
    Registered User
    Join Date
    06-08-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Selecting Range based on integer

    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
    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
    It keeps crashing on the last line though. Any help would be much appreciated, thanks!


    Edit : Nevermind! Just took me rewriting it on here to catch it.. thanks =)
    Last edited by odyeiop; 06-15-2009 at 10:31 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1