Convert cells with dashes to zeros.
Quick code needed to reset sheet copied from a damaged workbook, while having their format set to 'Accounting'.
This caused cells to show '-' instead of their actual zeros, so this small code was used to reset them back.
Access to code is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in MyDevLib.comLogin
StartFromCell, ForRows, ForColumns, Optional InSheet = "This", Optional InWB = "This"
Views 1 Downloads 0