I have a Excel document that repeating data such as the word "Location:" in cells all the way down.
I want to find that cell and get its contents then move to the next occurance get its contents and so on.
here is some code
TIA
DougP, MCP, A+
![[r2d2] [r2d2] [r2d2]](/data/assets/smilies/r2d2.gif)
I love this site and all you folks that helped me over the years!
I want to find that cell and get its contents then move to the next occurance get its contents and so on.
here is some code
Code:
Sub GetSampleNumbers()
Dim r As Range
Set r = Range("A1:A900").Find("Location:")
If Not r Is Nothing Then r.Select
End Sub
TIA
DougP, MCP, A+
![[r2d2] [r2d2] [r2d2]](/data/assets/smilies/r2d2.gif)
I love this site and all you folks that helped me over the years!