Hi all,
I have a quotation system that takes information from various cells dotted around a worksheet, and places them along a line per quote in a separate worksheet and returns a final price.
However, I can leave blank cells and the quote will still occur, because there is no way at the moment that the macro can check whether cells are empty and skip the quoting process.
I'm unsure how to check for blank cells efficiently, so that should one be blank the process stops - any ideas?
Bookmarks