Number Format

[Lionel Fridjhon]

I have variable that is declared as Long. When I use the
variable in an If statement such as
"If cells(r,c)=variable then"
I get the cell as a number but the variable insists on
appearing in quotes, indicating a string. As a result
the If statement comes out false.

Example If 2501 = "2501" then is false
How can I ensure that the variable is represented as a
number in the if statement so that thje answer is True?

Lionel

 

[Frank Kabel]

Hi
try something like
IF CLng(cells(r,c).value)=variable then

 

[Vasant Nanavati]

Can you post your code? A Long would never appear as a String. There must be
some confusion in the code that you have missed.

You could coerce the String to a Long using CLng but that really should not
be necessary with the proper declaration.

 

[Tom Ogilvy]

When you say the variable appears in quotes, where are you seeing it in
quotes?

try this before the if statement

msgbox cells(r,c).Value & "<-->" & variable & " " & cells(r,c).value =
variable