Do you have "cells" defined somewhere else? This generally happens when you
(mis)use a reserved word elsewhere in the project.

--

Vasant

"WayneL" wrote in message
...
Hi


I a writing VBA in Excel and I can not get the following line to run:

Sheets("Sheet1").cells(Row, Col).Value = Num


The "cells" part turns from "Cells" to "cells" when I hit return and I
guess
it treats it like an array not a cell location.

Can anyone help clear this up.

Cheers

Wayne