If cell >0 then run the following code else msgbox

[Taislin]

Hi.
I have this following code:

Please Login or Register  to view this content.

But in the sheet where this code will run, called "DATA", i have 2 cells that shows a value according the data stored in other sheet. These two cells in DATA sheet are K17 and K21.
What i want is that the code showned above only runs if K17 and K21 are greater than 0. If one of the cells are 0, or the two equals 0, the code should not run and display this message instead "The data is not avaiable. Please ait until more data is inserted and run the process again."

So if someone could help i would be really appreciated. I guess i have to put an If condition in the code above first but i dont jnow how to do that.

Thank you.

[jdelin86]

Hi,

Try something like this:

Please Login or Register  to view this content.

All I've done is create another routine that checks if K17 and K21 are greater than zero and if they BOTH are, then it runs the routine you defined in your post; otherwise it displays the error.

I'm sure other forum members can create something more efficient but that's a quick way I'd do it. Hope it works!

JD

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

[Taislin]

Everyone works. Many thanks to both. Really helped. Thank you. Liked the two approaches.