Hi,
I am having problems with a macro I wrote that basically fills things in two columns based on a set of values from other columns.
Lets say it looks like this (column B is based on column A):
A1 = Hi
A2 = Hello
A3 = Hi
A4 = Hello
A5 = Hi
A6 = Hello
A7 =
A8 = Hi
A9 = Hello
A10 = Bye
After the macro runs, column B should look like this:
B1 = 10%
B2 = 20%
B3 = 10%
B4 = 20%
B5 = 10%
B6 = 20%
B7 = 0%
B8 = 10%
B9 = 20%
B10 = 100%
The problem is this. When I run the macro, it stops at B7 and an error saying "Type Mismatch" pops up.
I am using if statements, and I tried all the posible combinations I could think of (if a7 = "", or if a7 is empty or if a7 = empty, etc).
Basically, I want to know what causes that error if possible in my case, if not just in general.
Does anyone know?
Thanks.