I am having difficulty figuring out how to accomplish this here. I want to search for a string value within in a range of cells. Then if that string value is found use that cells value to base a copy from that sheet to another. The latter portion I know I can do in VBA without much trouble, I can also find the cell that the string value is in, I just can't figure out how to then use that cells value, say its "C10" elsewhere within my VBA code.
I can find the string value in the cell using either of these two methods it seems, but I cannot seem to figure out how to then store that cell value where I found the string in within a variable to that I can reference it later on in the sub within my copy/paste code.
I can find the string value in the cell using either of these two methods it seems, but I cannot seem to figure out how to then store that cell value where I found the string in within a variable to that I can reference it later on in the sub within my copy/paste code.
VBA Code:
Dim StatusCol As Range
Dim FoundString As Range
Set StatusCol = Worksheets("Test").Range("C3:C500").Find("ABC123")
Set FoundString = 'Add code here that I can't figure out
VBA Code:
Dim Status As Range
Dim StatusCol As Range
For Each Status In StatusCol
If Status = "ABC123" Then
'Add code here that I can't figure out
End If
Next Status