Computer/Excel (3) 썸네일형 리스트형 VBA 엑셀 모든 시트의 함수를 값으로 변경 Developer > Visual Basic > Insert > Module > 아래값 복사하여 붙여넣기 > F5 Sub FormulaToValue() WCount = Worksheets.Count For i = 1 To WCount If Worksheets(WCount - i + 1).Visible Then Worksheets(WCount - i + 1).Select RCount = ActiveCell.SpecialCells(xlLastCell).Row CCount = ActiveCell.SpecialCells(xlLastCell).Column a = Cells(1, 1).Resize(RCount, CCount).Value Cells(1, 1).Resize(RCount, CCount) = a End I.. Excel macro send key Application.SendKeys("{UP}") Application.SendKeys("{DOWN}") Application.SendKeys("{LEFT}") Application.SendKeys("{RIGHT}") Application.SendKeys("{ENTER}") BACKSPACE/{BACKSPACE} or {BS} BREAK/{BREAK} CAPS LOCK/{CAPSLOCK} CLEAR/{CLEAR} DELETE or DEL/{DELETE} or {DEL} DOWN ARROW/{DOWN} END/{END} ENTER (numeric keypad)/{ENTER} ENTER/~ (tilde) ESC/{ESCAPE} or {ESC} HELP/{HELP} HOME/{HOME} INS/{INSERT.. Excel macro - Visual Basic loop To loop, insert following 'First of the code For I = 0 To 999 ' End of the code Next I 이전 1 다음