View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default "Cells" become "CellS" - why?

Gunnar,

It sounds to me that you have declared a variable cellS somewhere.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Gunnar Johansson" wrote in message
...
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