Thread: Macro analyses cells in 2 columns . If same text found , keeps row
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Macro analyses cells in 2 columns . If same text found , keeps
Hi,

It's in this line

If InStr(1, c.Value, c.Offset(, 2).Value, vbTextCompare) < 1 Then


Column D is offset 2 columns from B so for Q change the offset to 15

If InStr(1, c.Value, c.Offset(, 15).Value, vbTextCompare) < 1 Then

Mike

"andrei" wrote:

one more thing : If i need to compare B column with Q column instead of D
column , what changes in the macro should be done ?

Reply With QuoteReply With Quote