View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default "Cells" become "CellS" - why?

Just to add to Bob's reply:

Type:
Dim Cells
somewhere in your module (anywhere)
hit enter
and then delete that line.



Gunnar Johansson wrote:

Hi,

I wrote a For Each Next statement and worked and referred to
"Activesheet.Cells(ActRow, 1).Value " etc and suddenly it started to
"correct" the word from cells to cellS, with a capital S in the end. now i
notice all cells in the workbook has also changed to cellS...

It is not find/replace i'm talking about, if I try to write
//...Range(Cells(2,3)).Value cells automatically changes to cellS instead.
It seem to work the same, still, but....
WHY ???

Regards
Gunnar Johansson


--

Dave Peterson