Hello and thanks in advance.
I'm trying to write a simple VBA code to loop through values in the range A14:A138 and based on the value (of a possible four values) in any row of that range, populate the adjacent column in the same row with a conditional result. For example if A14 = "Cat", then B14 = "I"; if instead A14 = "Dog", B14 = "II", etc. If there is no value in column A, the result should be blank (i.e. "").
I think I'm close, but my struggles I believe are in coding the destination range since I can get it to work for just one cell in B!
Below is my code that is not working...
Any help is much appreciated! Thanks, Chris
Please Login or Register to view this content.