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