Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    Louisville, Kentucky, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Extending a selection using Find? (2000)

    In Word, I can use F8 to start an extended selection process, use Find to extend the selection, and then stop the extended selection. In Excel 2000, the F8 starts the extended selection, but bringing up Find turns it off?!?!?

    Any other answer to starting a cell selection, press F8, do a Find, with everything in between selected?

    Thanks

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Extending a selection using Find? (2000)

    You might try this macro
    <pre>Sub SelectBetweenFind()
    Dim CellContent As Integer
    Dim StartCell As Range, EndCell As Range
    Set StartCell = ActiveCell
    CellContent = ActiveCell.Value

    Cells.Find(What:=CellContent, After:=ActiveCell, _
    LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByRows, _
    SearchDirection:=xlNext, MatchCase:=False).Activate
    Set EndCell = ActiveCell
    Range(StartCell, EndCell).Select
    End Sub
    </pre>


    Although I'm not sure if the CellContent variable is best defined as a Integer. Perhaps someone else has a thought on this?

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Extending a selection using Find? (2000)

    Define cellcontent as a variant and you should be OK.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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