Cells(col,row) keep moving to lower case and I can not ref. a cells in a differnet sheet

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

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

--

Vasant

"WayneL" <home@wlawson-nomorespam.co.uk> wrote in message
news:nHdbe.5593$TT6.1411@newsfe3-win.ntli.net...
> 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
>
>

I just tested this on xl2002

Sub ddd()
num = 12345 '"dd"
Row = 1
col = 5
Sheets("Sheet1").Cells(Row, col).Value = num
End Sub

--
Don Guillett
SalesAid Software
donaldb@281.com
"WayneL" <home@wlawson-nomorespam.co.uk> wrote in message
news:nHdbe.5593$TT6.1411@newsfe3-win.ntli.net...
> 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
>
>