| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why # appears on its own ?
while using this code:
For each c Worksheets("Sheet1").Range("A2:A100").Cells If c.Value = 235454567890 Then A hash sign appears after this number in the coding. What does it signify ? Milind --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why # appears on its own ?
Milind,
It declares the number as a Double data type. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Milind" wrote in message ... while using this code: For each c Worksheets("Sheet1").Range("A2:A100").Cells If c.Value = 235454567890 Then A hash sign appears after this number in the coding. What does it signify ? Milind --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Name appears twice in 15 days | Excel Discussion (Misc queries) | |||
| What number appears the most? | Excel Discussion (Misc queries) | |||
| message box appears and appears | Excel Discussion (Misc queries) | |||
| Zero Appears | Excel Discussion (Misc queries) | |||
| Why sometimes I try to use "=" and it appears "pts"?? | Excel Discussion (Misc queries) | |||
Linear Mode
