Formula & Macro

N

nik_gujarathi

Hello friends
I have a formula in each cell of column L and R.
Example
Formula in cell L6 is =IF(J6<>K6,0,1) & Formula in cell R6 is =
IF(P6<>Q6,0,1)
I was looking for a macro that will give a error message "Warning" if
the value of cells in column L and R is 1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula & Macro 1
Excel - Wich Function should I use? 1
Formula Problem with IF (Negative and Positive Numbers) 2
Excel does not accept text format! 0
Drop down list control value in vba 2
Range.Find problem 3
I'd like to modify mt Macro ... 9
Run macro on all files in a specific folder 3

Top