How to match the value of active cell with other value cell
What is the code to match the value of active cell with other value cell in all workbook
I mean :
Example for one cell
[vba]If ActiveCell.Value = Cells(1, 3).Value Then MsgBox "Yes"[/vba]
I want to check for all cells in workbook
[vba]If ActiveCell.Value = "any cells.Value in workbook" Then MsgBox "Yes"[/vba]
A multiple sheet workbook, or just the single sheet?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
How I don't know
Then how are we supposed to?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I'm so sorry because I was rush and couldn't understand .
A multiple sheet workbook
Posting Permissions
Reply With Quote
