VBA macro for Excel for extracting and ''depositing'' text between brackets...

Dear Catherine...
This actually works and even I (a complete programming ignoramus) have been able to implement it. I'm very grateful - thank you very much - you have saved me hours and hours of painstaking manual selecting, cutting and pasting.
I wonder if I could ask you one further favour? If you have time, could you possibly tell me - only if you have a spare ten minutes of so - what each line of code does? I'm trying to learn VBA, but am doing it in a rather haphazard, non-linear way. If you could explain the rationale behind each snippet, I'm sure I could learn something...
Thanks again.
All the best...

Josh

Hey,

Here you go…

Sub CopyAndDepositTextWithinBrackets()
'Declaring variables like Integers and Strings, and object types like Ranges
Dim rngCell As Range
Dim strName As String
Dim OpenBracket As Integer
Dim CloseBracket As Integer
'Define a For..Next loop from cell A1 to the last entry in column A
For Each rngCell In Range("A1", Range("A1").End(xlDown))
'Store the entry in the rngCell
strName = rngCell.Value
'Find the position of the brackets
OpenBracket = InStr(1, strName, "<")
CloseBracket = InStr(1, strName, ">")
'Extract the value inside the brackets and write it to the next cell to the right
rngCell.Offset(0, 1).Value = Mid(strName, _
OpenBracket + 1, CloseBracket - OpenBracket - 1)
'Loop until all cells is done
Next rngCell
End Sub

Cath

…remember to mark the answer as answered if it was what you were looking fore