버튼을 누를 때 마다 표시되는 문구가 달라지는 매크로 버튼 하나로 단계적 절차를 표현할 때 활용가능 Sub Calculate() Application.ScreenUpdating = False With ActiveSheet.Buttons(Application.Caller) If .Caption = "Sum" Then Cells(12, 1).Value = "=R[-2]C+R[-1]C" Cells(12, 2).Value = "=R[-2]C+R[-1]C" Cells(12, 3).Value = "=R[-2]C+R[-1]C" Cells(9, 1).Value = .Caption .Caption = "subtract" ElseIf .Caption = "subtract" Then Cells(12, 1).Value = "..
* 링크 못 찾음 Thus, I was thinking that there should be a fast way to calculate the first few numbers with System.Collections.ArrayList as far as I have written about a helper to sort arrays and range sorter. So, as far as it can be obviously solved with a N^2 complexity algorithm it is quite easy to be done: Public Sub TaxiCabNumber() Dim a As Long Dim b As Long Dim lastNumber As Long Dim cnt As Lo..
*스크랩 링크 못 찾음.. Yup! The named ranges are visible. You “SpecialPassword” can be seen by anyone. What should you do? Option 1 – use a database and proper hashing for storing of sensitive information. Option 2 – hide the names, from the Name-Manager, thus the worksheet would still refer them, but they will be not visible: This is the way to achieve it with VBA: Sub UnhideAllNames() Dim tempName As ..