Hoping I can get some help with a problem I'm having, below is a snipit of code from my worksheet_change code. The Case numbers reference columns R and S on my spreadsheet. I am doing simple division, S/R and post answer in Column Q. It works fine in I enter data in column R then Column S but If I enter data in Column S first I get a division by 0 error. I would like to prevent this as the end user of the spreadsheet may enter the values in any order.
Can someone please help. Thanks