bomberman411
Board Regular
- Joined
- Oct 23, 2007
- Messages
- 169
Hello all,
I have column A:10 to A:5000. All cells have numbers in them A:10 = 0001, A:11 = 0002, etc...
I would like to scan all these cells just once to find all dumps and correct them. This would be a one time thing to correct past errors.
I tried using conditional formatting but it didn't show any difference, and I know for a fact that there is 1 dup in there somewhere, I just can't find it.
Should I use VBA code instead? if so, how?
Thanks
I have column A:10 to A:5000. All cells have numbers in them A:10 = 0001, A:11 = 0002, etc...
I would like to scan all these cells just once to find all dumps and correct them. This would be a one time thing to correct past errors.
I tried using conditional formatting but it didn't show any difference, and I know for a fact that there is 1 dup in there somewhere, I just can't find it.
Should I use VBA code instead? if so, how?
Thanks