edwinwang.com

Category: Excel

  • 破解 Excel 密码的宏

    —

    by

    Edwin
    in

    破解 Excel 密码的宏： Sub PasswordBreaker() 　　Dim i As Integer, j As Integer, k As Integer 　　Dim l As Integer, m As Integer, n As Integer 　　Dim i1 As Integer, i2 As Integer, i3 As Integer 　　Dim i4 As Integer, i5 As Integer, i6 As Integer 　　On Error Resume Next 　　For i = 65 To 66:…

  • Excel 单元格中如何换行？Word Wrap in Excel, VB.net

    —

    by

    Edwin
    in ,

    在单元格中想要换行，只觉得按回车 Enter 键，会发现选中了下一个单元格。   那应该怎么做呢？ 答案： Alt + 回车 (Enter) 对于编程输入，Alt + Enter 是硬回车。在 VB.NET 中相当于 Chr(10) 或者 vbLF。别的语言可以使用 ASCII 10, Char(10) 得到。 To word wrap in a single cell simply use Alt + Enter at a point the words should be wrapped.