Highlighted Iferror value

[Sarankbm]

Hi Friends,

I was run the Vlookup vba code if any error throw the same lookup (First) value that value
highlighted any one color. but error appeared

Please find below mention code.
highlighted error bold letter

Code:

sub aa()
Range("a:a") = Application.IfError(Application.WorksheetFunction.VLookup(Range("a:a"), _
Worksheets("Sheet2").Range("A1:C10"), 1, False), Range("a:a").Font.ColorIndex = vbRed)
end sub


Kindly help me

Regards,
Saran.K

 

[Hui]

Saran.K

Can you please attach a sample work book with a sample of what you are trying to achieve

 

[NARAYANK991]

Hi ,

See the attached workbook.

Narayan

 

[Sarankbm]

Hi Narayan,

Really thank you

Ragards,
Saran.K