ktab
Well-known Member
- Joined
- Apr 21, 2005
- Messages
- 1,297
Hello,
At the following code how may i exclude the activecell's range from range?
columns(1).find(activecell.value,lookat:xlwhole)
I want each time an entry is made to look for dubs (at worksheet change event), so i do not want to look for activecell's value too.
Thank you
Kostas
At the following code how may i exclude the activecell's range from range?
columns(1).find(activecell.value,lookat:xlwhole)
I want each time an entry is made to look for dubs (at worksheet change event), so i do not want to look for activecell's value too.
Thank you
Kostas