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