"Cells" become "CellS" - why?

[Gunnar Johansson]

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

 

[Bob Phillips]

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)

 

[Dave Peterson]

Just to add to Bob's reply:

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

 

[Gunnar Johansson]

I find no declaration anywere, I have both tried search/find and visually
passed through all code. None!

All my "cells" have been "cellS" and I cant change, it just convert it back
to cellS again...
Any functions in Excel's VBA GUI to check for?

/Regards

 

[Gunnar Johansson]

Great. It worked.
This is a feature I haven't read somewhere...

/Regards