PDA

View Full Version : How to match the value of active cell with other value cell



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"

Bob Phillips
01-02-2008, 03:22 PM
A multiple sheet workbook, or just the single sheet?

Nader
01-02-2008, 04:18 PM
How I don't know

Bob Phillips
01-02-2008, 04:43 PM
Then how are we supposed to?

Nader
01-02-2008, 06:44 PM
I'm so sorry because I was rush and couldn't understand .

A multiple sheet workbook