View Full Version : Solved: Checking For Data In A Cell
drums4monty
12-11-2006, 02:33 PM
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
12-11-2006, 02:34 PM
if activesheet.range("E43") >= 1 then
msgbox "Cell E43 has a value less than 1"
End if
HTH
Cal
drums4monty
12-11-2006, 02:54 PM
Thanks Cal
That works great, just the job.
Alan
Charlize
12-12-2006, 02:54 AM
if activesheet.range("E43") >= 1 then
msgbox "Cell E43 has a value less than 1"
End if
HTH
Cal
less ?:doh:
Charlize
Oooooh... way to burn :devil2:
CBrine
12-12-2006, 07:31 AM
less ?:doh:
Charlize
:nya: :confused3
Well, thank you for pointing out that error THAT EVERYONE else missed.
:-)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.