Sub ReplaceNumbers() Dim rowNum As Integer Dim colNum As Integer Dim cellValue As String Dim newCellValue As String Randomize ' 初始化随机数生成器

' 循环替换每一行中的数字
For rowNum = 1 To ActiveSheet.UsedRange.Rows.Count
    For colNum = 1 To ActiveSheet.UsedRange.Columns.Count
        cellValue = ActiveSheet.Cells(rowNum, colNum).Value
        If IsNumeric(cellValue) And Len(cellValue) = 2 Then
            ' 随机决定是否替换该数字为星号
            If Int(Rnd() * 2) = 1 Then
                newCellValue = Replace(cellValue, Mid(cellValue, Int(Rnd() * 2) + 1, 1), "*")
                ActiveSheet.Cells(rowNum, colNum).Value = newCellValue
            End If
        End If
    Next colNum
Next rowNum

End Sub

写一段VBA代码,将一行的三个两位数中随机用替换成星号,然后再转到第二行重复第一步的操作,一直替换完所有的行。

原文地址: https://www.cveoy.top/t/topic/vTh 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录