Results 1 to 3 of 3

After the "Find" function in VBA......

Threaded View

Kimber20 After the "Find" function in... 05-13-2012, 12:50 AM
Sa DQ Re: Hope this help! 05-13-2012, 08:03 AM
Sa DQ Re: Use FIND() methode in UDF 05-13-2012, 08:20 AM
  1. #1
    Registered User
    Join Date
    01-26-2012
    Location
    Eden Praire
    MS-Off Ver
    Excel 2007
    Posts
    8

    After the "Find" function in VBA......

    I have a Find function used in conjuction with unhiding a sheet, the Find function works, but you have to scroll to find the cell. When you use the "Find" function in Excel it scrolls to the cell and centers it in view, but in the macro it just goes to the cell, but not in view.....any help will be great.

    Thanks,
    Application.ScreenUpdating = False
    Sheets("Sheet1").Visible = True
    Sheets("Sheet1").Select
    Range("A1").Select
    Cells.Find(What:="1", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
            xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
            False, SearchFormat:=False).Activate       
    Application.ScreenUpdating = True
    
    End Sub


    End Sub
    Last edited by Kimber20; 05-13-2012 at 01:20 AM.

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