akamax_power
06-10-2008, 12:25 PM
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
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