Solved: Checking For Data In A Cell

[drums4monty]

Hi All

How do I check to see if Cell E43 has a 1 or greater in it then display a msg box with some warning?

Regards

Alan

[CBrine]

if activesheet.range("E43") >= 1 then
msgbox "Cell E43 has a value less than 1"
End if


HTH
Cal

[drums4monty]

Thanks Cal

That works great, just the job.

Alan

[Charlize]

if activesheet.range("E43") >= 1 then
msgbox "Cell E43 has a value less than 1"
End if


HTH
Cal
less ?:doh:

Charlize

[moa]

Oooooh... way to burn :devil2:

[CBrine]

less ?:doh:

Charlize

:nya: :confused3
Well, thank you for pointing out that error THAT EVERYONE else missed.

:-)