Nader
01-02-2008, 02:26 PM
What is the code to match the value of active cell with other value cell in all workbook
I mean :
Example for one cell
If ActiveCell.Value = Cells(1, 3).Value Then MsgBox "Yes"
I want to check for all cells in workbook
If ActiveCell.Value = "any cells.Value in workbook" Then MsgBox "Yes"
I mean :
Example for one cell
If ActiveCell.Value = Cells(1, 3).Value Then MsgBox "Yes"
I want to check for all cells in workbook
If ActiveCell.Value = "any cells.Value in workbook" Then MsgBox "Yes"