reVidia
09-03-2008, 11:41 AM
Hi, I am trying to write a macro to take in a range of cells and then display a text next to it to indicate if the value of each respectively cell exist anywhere in the workbook.
I roughly know the flow but as I am still new to vba i am facing issue to get the codes out.
1. 1st input box ask for the range start
2. 2nd input box ask for range end
3. loop from the first cell in the range, get cell value
4. declare ws as worksheet, for each ws in worksheet, find the value
5. if value exist in workbook, indicate found else put not found
6. loop till end.
Would be glad if someone can give me some pointers thanks.
I roughly know the flow but as I am still new to vba i am facing issue to get the codes out.
1. 1st input box ask for the range start
2. 2nd input box ask for range end
3. loop from the first cell in the range, get cell value
4. declare ws as worksheet, for each ws in worksheet, find the value
5. if value exist in workbook, indicate found else put not found
6. loop till end.
Would be glad if someone can give me some pointers thanks.