"Row" is one of the terms which cannot be defined as a variable name by the
user, since it is used internally by VBA.

Change the variable name.

"fmistry" wrote:

I am using the cells function in a macro. For example,
Cells(14,10) = Cells (Row,5)
When I run the macro, it stops at this line and shows an error. Row
is defined as an Integer and has value.

What is going on?

Thanks.