Results 1 to 4 of 4

Return Row Number?

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2007
    Posts
    57

    Return Row Number?

    I'm trying to get the row number of a cell that was selected in a find.


    Example:

    
    Sub findRowNumber()
    '
    '
        Cells.Find(What:="104", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
            xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _
            .Activate
            
        ActiveCell.Select
            
        MsgBox (" The Row number of the selected cell is " & rw.Row)
        
            
    End Sub

    As always, Thanks for your help, Phil
    Last edited by VBA Noob; 01-22-2008 at 09:38 AM.
    Phil
    Technician
    City of Clinton, SC
    SCADA, GIS, Utility Billing, Networking
    I'm doing the best I can with the little bit I know.

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