I want to check the value in individual cell within a selected range, and if any cell found blank I want to put some
value such as N/A for some cells, that should have string as value and -1 for some cell that should have numerical value. I want to create the Macro in 1 workbook and run it for other workbooks. How can I do it.
Could any one please give me a suggestion.