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

My Own Work

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

Views 3
Downloads 0

VBA-Excel Math
ANmarAmdeen
968
Attachments
Revisions

v1.0

Tuesday
March
14
2023