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.
Bookmarks