Question

EXCEL表格函数定义问题在表格中定义某列,例如：B列,1=A;2=B;3=C;4=D.,请问如何写入函数?不能定义整个

Answer 1

可以用VBA实现.

右击工作表标签>查看代码>粘贴下面的代码即可.

Private Sub Worksheet_Change(ByVal Target As Range)

On Error Resume Next

Application.EnableEvents = False

For Each c In Target.Cells

With c

If .Column = 2 Then .Value = Chr(64 + .Value)

End With

Next

Application.EnableEvents = True

End Su