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

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

--
Regards
Frank Kabel
Frankfurt, Germany


Lionel Fridjhon wrote:
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

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.

--

Vasant


"Lionel Fridjhon" wrote in message
...
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

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

--
Regards,
Tom Ogilvy


"Lionel Fridjhon" wrote in message
...
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