To clarify, Weight is a variable, type Variant as it is not defined. As such, it does not have a Value property.

So, the first solution avoids the use of the variable on the premise that it is only needed for this step.

The second solution removes the offending Value property.

Note that, as EmptyRow is determined outside the loop, all the results will go in the same cell. You probably need to make it: Cells(EmptyRow+i, 5).value


Regards, TMS