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

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

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

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

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

"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