stenlake1
06-14-2007, 03:41 AM
I have a list of values, I would like my VBA script to scroll through these values until it finds a different value from the last.
Column A
256 (So want it to find this value)
256 (Then ignore this as previous to the last)
584 (Then find this value)
584
584
584
Is it best to use the "Selection.Find" command? Each time it finds a new value I would like it to prompt me so I can make a choice (going to insert another script in!)
Thanks for your help in advance :)
Column A
256 (So want it to find this value)
256 (Then ignore this as previous to the last)
584 (Then find this value)
584
584
584
Is it best to use the "Selection.Find" command? Each time it finds a new value I would like it to prompt me so I can make a choice (going to insert another script in!)
Thanks for your help in advance :)