Hi there,
I was wondering if anyone could help me out. I have a range of codes in my excel sheet which should be replaced with a different value. For example; codes A, B, and C should be replaced with the value 1. So i need a macro that can do this. Because the codes are not numeric, I can't use a range (i think?)
Does anyone have an idea?
thanks!
Bookmarks