Consulting

Results 1 to 3 of 3

Thread: Solved: Find cell and return value as string

  1. #1

    Solved: Find cell and return value as string

    Ok, I'm having a little trouble with this.

    I want to be able to find the cell in the sheet "Project Summary" that contains a specific ID and return the value of an offset cell the found cell as a string.

    something like:

    Dim sht As String
    sht = cells.find(what:=idstr, after:=Sheets("Project Summary").range("A1"),).offset(0,2).value

    This doesnt work but maybe you get the idea.

    Thanks,
    Gerald

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    [vba]

    Dim sht As String
    With Sheets("Project Summary")
    sht = .Cells.Find(what:=idstr).Offset(0, 2).Value
    End With
    [/vba]
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    That was easy, i feel like an idiot now

Posting Permissions

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