Sub 宏1() If Trim$(Cells(1, 1).Value) = "借" Then Cells(1, 3).Value = Chr(43) & Cells(1, 3).Value End If
If Trim$(Cells(1, 2).Value) = "贷" Then Cells(1, 4).Value = Chr(45) & Cells(1, 4).Value End If End Sub'Cells(1, 3).Value 即行1列3的值,其他类推 'Chr(43) 即加号(+),'Chr(45) 即减号(-) '必须将单元格的格式设置为文本
For i = 1 To Sheet1.UsedRange.Count Select Case Sheet1.Cells(i, 1) Case "借" Sheet1.Cells(i, 3) = "+" & Sheet1.Cells(i, 3) Case "贷" Sheet1.Cells(i, 3) = "-" & Sheet1.Cells(i, 3) Case Else End Select
If Trim$(Cells(1, 1).Value) = "借" Then
Cells(1, 3).Value = Chr(43) & Cells(1, 3).Value
End If
If Trim$(Cells(1, 2).Value) = "贷" Then
Cells(1, 4).Value = Chr(45) & Cells(1, 4).Value
End If
End Sub'Cells(1, 3).Value 即行1列3的值,其他类推
'Chr(43) 即加号(+),'Chr(45) 即减号(-)
'必须将单元格的格式设置为文本
我是说EXCLE文件已经形成,能不能自动判断记录的多少然后自动实现功能。
Dim i As Long
For i = 1 To Sheet1.UsedRange.Count
Select Case Sheet1.Cells(i, 1)
Case "借"
Sheet1.Cells(i, 3) = "+" & Sheet1.Cells(i, 3)
Case "贷"
Sheet1.Cells(i, 3) = "-" & Sheet1.Cells(i, 3)
Case Else
End Select
Next i
End Sub