View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Ron is offline
external usenet poster
 
Posts: 250
Default Storing textin a variable and comparing to a second value

Thanks very much. It was the
If Range("A2").Value = Range("C2").Value Then
syntax I couldn't figure out.

Ron

"FSt1" wrote:

hi
a little sketchy on details but
try this..
Sub Matchit()
If Range("A2").Value = Range("C2").Value Then
MsgBox "match"
Else
MsgBox "no match"
End If
End Sub

regards
FSt1

"Ron" wrote:

Not sure if I'm going about this right.
I need to go compare text (a name) in a cell with text (a name) in another
cell.

After that I do some stuff, which I should be able to handle. I just can't
figure the VBA syntax to do that. It will be part of a larger macro.

New to VBA and can't seem to find a web site that helps.

Ron