Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Cells" become "CellS" - why?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Cells" become "CellS" - why?
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 "Bob Phillips" skrev i meddelandet ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Cells" become "CellS" - why?
Great. It worked.
This is a feature I haven't read somewhere... /Regards "Dave Peterson" skrev i meddelandet ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I disable "cutting cells" and "drag and drop "in excel ? | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |