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

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