Hi all,
I am having some issues with repeating the macro using the 'next' function. What I want to do is change any cell that has a '0' in it to '1E-10'
I currently have this so far for one sheet but am having some difficulty exiting the loop and going to the next worksheet -
Sub Replace0()
Dim ActiveCell As Variant
For Each ActiveCell In Range("A1:AI1000")
If ActiveCell.Value = "0" Then
ActiveCell.Value = "0.0000000001"
End If
Next
End Sub
Any help would be much appreciated.
Bookmarks