Convert_Dash_to_Zero

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.


Public

Tested

Original Work

StartFromCell, ForRows, ForColumns, Optional InSheet = "This", Optional InWB = "This"

Views 3
Downloads 0


ANmarAmdeen
547
Attachments
Revisions

v1.0

Tuesday
March
14
2023