Matching contents of a cell full of text
I'm trying to write a macro that will compare the contents of two
nearby cells to see if they are identical. The cells all contain the
names of creative placements, so they are not numerical values.
I'm thinking something like,
sub test
if activecell.offset(5, -1) = activecell.offset(5,-2) then
Msgbox("These are the same")
' And then do any action I want
Else
Msgbox("These are not the same")
End if
End sub
does anybody know how to effectively do that first If statement?
Thanks,
-Brien
|