About Us

Ronbo

What is wrong with this simple code. It always returns "equals"?

Private Sub Worksheet_Activate()
If H20 < I20 Then MsgBox "does not equal" Else _
MsgBox "equals"

End Sub

Thanks

JMB

I think excel is treating H20 and I20 as variables (whose values are both
zero).
Try:

If Range("H20").Value < Range("I20").Value

"Ronbo" wrote:

What is wrong with this simple code. It always returns "equals"?

Private Sub Worksheet_Activate()
If H20 < I20 Then MsgBox "does not equal" Else _
MsgBox "equals"

End Sub

Thanks

Ronbo

Thanks, it works perfect.

"JMB" wrote:

I think excel is treating H20 and I20 as variables (whose values are both
zero).
Try:

If Range("H20").Value < Range("I20").Value

"Ronbo" wrote:

What is wrong with this simple code. It always returns "equals"?

Private Sub Worksheet_Activate()
If H20 < I20 Then MsgBox "does not equal" Else _
MsgBox "equals"

End Sub

Thanks

JMB

you're welcome.

"Ronbo" wrote:

Thanks, it works perfect.

"JMB" wrote:

I think excel is treating H20 and I20 as variables (whose values are both
zero).
Try:

If Range("H20").Value < Range("I20").Value

"Ronbo" wrote:

What is wrong with this simple code. It always returns "equals"?

Private Sub Worksheet_Activate()
If H20 < I20 Then MsgBox "does not equal" Else _
MsgBox "equals"

End Sub

Thanks

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA code question	peyman	Excel Discussion (Misc queries)	5	February 5th 09 12:04 AM
question on VB code	peyman	Excel Discussion (Misc queries)	6	October 22nd 07 11:47 PM
code question	Gary Keramidas[_2_]	Excel Programming	16	July 19th 05 05:13 PM
Please help with vba code question	Temp12	Excel Programming	2	July 14th 04 09:31 PM
VBA CODE Question	Gary[_5_]	Excel Programming	2	July 29th 03 03:45 AM

Menu

About Us