{"id":776,"date":"2022-12-06T12:07:32","date_gmt":"2022-12-06T03:07:32","guid":{"rendered":"https:\/\/chaerang.net\/?p=776"},"modified":"2022-12-06T12:07:33","modified_gmt":"2022-12-06T03:07:33","slug":"excel-vba-%ea%b0%80%ea%b3%84%eb%b6%80-%eb%a7%8c%eb%93%a4%ea%b8%b01","status":"publish","type":"post","link":"https:\/\/chaerang.net\/?p=776","title":{"rendered":"Excel – VBA : \uac00\uacc4\ubd80 \ub9cc\ub4e4\uae301"},"content":{"rendered":"\n

\uc548\ub155\ud558\uc138\uc694 \ucc44\ub791\uc774 \uc544\ube60 \ud504\ub9ac\uc544\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc624\ub298\uc740 \uc5d1\uc140\uc744 \uc0ac\uc6a9\ud574\uc11c \uac00\uacc4\ubd80\ub97c \ub9cc\ub4e4\uc5b4 \ubcfc\uac81\ub2c8\ub2e4.
\uadf8\ub0e5 \uc5d1\uc140\uc744 \uc0ac\uc6a9\ud574\uc11c \ub9cc\ub4dc\ub294 \uac70\ub77c\uba74 \ub204\uad6c\ub77c\ub3c4 \ub9cc\ub4e4\uc218 \uc788\uaca0\uc8e0 ^^
\uc800\ud76c\ub294 VBA\uac00 \ucd94\uac00\ub41c \uac00\uacc4\ubd80\ub97c \ub9cc\ub4e4\uac81\ub2c8\ub2e4.<\/p>\n\n\n\n

VBA\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \uac04\ub2e8\ud558\uac8c\ub294 \uc790\ub3d9\uc73c\ub85c \uc218\uc2dd\uc744 \ub123\uac8c \ub9cc\ub4e4 \uc218 \ub3c4 \uc788\uad6c\uc694,
\uac00\uacc4\ubd80 \uc785\ub825\ud560 \ub0b4\uc6a9\uc744 \ud31d\uc5c5\uc73c\ub85c \ub744\uc6cc\uc11c \uc785\ub825\ud558\uac8c \ub9cc\ub4e4\uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.
\ub450\uac00\uc9c0 \ubaa8\ub450 VBA\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc774\ub77c\uace0 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uba3c\uc800 VBA\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc790\ub3d9\uc73c\ub85c \uc218\uc2dd\uc744 \ub123\ub294 \ubc29\ubc95\uc744 \uc54c\ub824\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc6b0\uc120, \uac00\uacc4\ubd80 \ud2c0\uc744 \uc7a1\uc544\uc57c\uaca0\uc8e0.
\ud2c0\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \uc7a1\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\uc2ec\ud50c\ud558\uc8e0? \uc77c\ubc18\uc801\uc73c\ub85c \ub9ce\uc774 \ubcfc \uc218 \uc788\ub294 \ud615\ud0dc\ub85c \uc7a1\uc558\uc5b4\uc694.
\uc790 \uc774\uc911\uc5d0\uc11c \uc790\ub3d9 \uc218\uc2dd\uc744 \uac78 \uc218 \uc788\uc744 \ub9cc\ud55c \uacf3\uc740 \ucd1d 2\uacf3\uc785\ub2c8\ub2e4.
No.\uc640 \uc794\uc561\uc785\ub2c8\ub2e4.
\ub098\uba38\uc9c0\ub294 \ub2e4 \uc785\ub825\ud574\uc57c\uc9c0\ub9cc \ub418\ub294 \ud56d\ubaa9\ub4e4\uc774\uc8e0.<\/p>\n\n\n\n

VBA\ub97c \uac78 \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.
– \uc77c\uc790, \uc785\uae08, \ucd9c\uae08, \ube44\uace0 \uc911\uc5d0 \uac12\uc774 \uc785\ub825\ub418\uba74 \uc218\uc2dd\uc744 \uc790\ub3d9 \uc785\ub825\ud55c\ub2e4.<\/p>\n\n\n\n

\uc77c\ub2e8 \uc6b0\ub9ac\uac00 \uc54c\uc544\uc57c \ud558\ub294 \ub370\uc774\ud130\ub294 2\uac00\uc9c0\uc785\ub2c8\ub2e4.
\uc140\uc744 \uc774\ub3d9\ud588\uc744 \ub54c, \uc774\uc804\uc758 \uc140\uc758 Row\uac12\uacfc Column\uac12\uc774\uc8e0.<\/p>\n\n\n\n

\uc77c\ub2e8 \uc774\uc804 \uc140\uc758 Row\uac12\uacfc Column\uac12\uc744 \uc785\ub825\ud560 \uc804\uc5ed \ubcc0\uc218\ub97c \uc9c0\uc815\ud560 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc77c\ub2e8 Alt+F11\uc744 \ub20c\ub7ec\uc11c VBA \ucc3d\uc744 \ub744\uc6b0\uc138\uc694.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\uc774\ub807\uac8c \ubcf4\uc774\uba74\uc11c Sheet1\uc774 \uc120\ud0dd\ub418\uc5b4 \uc9c4\uac83\uc774 \ubcf4\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc606\uc5d0 \uce78\uc5d0\ub2e4\uac00 \ub2e4\uc74c\uacfc \uac19\uc774 \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

Dim r, c As Integer<\/p>\n\n\n\n

Dim\uc740 \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\ub294 \uad6c\uc808\uc785\ub2c8\ub2e4.
\ubcc0\uc218\uc758 \uc774\ub984\uc740 r\uacfc c\uc774\uba70, \ud0c0\uc785\uc740 \uc815\uc218\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

r\uc740 Rows\uc758 \uc57d\uc790\uc774\uba70, c\ub294 Column\uc758 \uc57d\uc790\uc785\ub2c8\ub2e4.
\uc774\ub807\uac8c \ubcc0\uc218\uba85\uc740 \uc790\uc2e0\uc774 \uc54c\uc544\ubcf4\uae30 \uc26c\uc6b4 \uac83\uc73c\ub85c \ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.
\ub2e4\ub9cc, \ub108\ubb34 \ubcc0\uc218\uba85\uc744 \ub514\ud14c\uc77c\ud558\uac8c \uc7a1\uc73c\uc2dc\uba74 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\uc27d\uac8c \ub9d0\ud574 \ubcc0\uc218\ub97c rows\ub85c \uc7a1\uc544\ubc84\ub9ac\uba74, VBA \uba85\ub839\uc5b4 \uc911\uc5d0 \uc788\ub294 Rows\ub77c\ub294 \uba85\ub839\uc5b4\uc640 \uc911\ucca9\uc774 \ub418\uc5b4\ubc84\ub9ac\uae30 \ub54c\ubb38\uc5d0 \uad6c\uc808 \uc624\ub958\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.
\uadf8\ub798\uc11c row_check\ub098, r \ub4f1 \ub2e8\uc5b4+\ucd94\uac00\ubb38\uad6c \ub610\ub294 \uc644\uc804 \uc57d\uc790\uc758 \ud615\ud0dc\ub85c \uc7a1\uc73c\uc2dc\ub294\uac8c \uc88b\uc2b5\ub2c8\ub2e4.
\uc804 \uae38\uac8c \uc4f0\ub294\uac8c \uc2eb\uc5b4\uc11c \uadf8\ub0e5 1\uae00\uc790\ub85c \ud241\uccd0\uc694 \u314e\u314e\u314e\u314e.<\/p>\n\n\n\n

public\ub098 private \ubb38\uad6c \uc548\uc774 \uc544\ub2cc \ubc16\uc5d0 Dim\uc73c\ub85c \uc120\uc5b8\ud55c \ubcc0\uc218\uc758 \uacbd\uc6b0 \ubaa8\ub4e0 \ud558\uc704 \uc9d1\ub2e8\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4\ub294 \uc7a5\uc810\uc774 \uc788\uc73c\uba70,
\ud558\ub098\uc758 \uba85\ub839\uc5b4 \uc9d1\ub2e8\uc774 \uc644\ub8cc\ub418\uc5b4\ub3c4 \ud574\ub2f9 \ubcc0\uc218\ub294 \uc720\uc9c0\ub41c\ub2e4\ub294 \uc7a5\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4.(public\ub098 private \uad6c\uc808\uc548\uc758 \ubcc0\uc218\ub294 \ud574\ub2f9 \uba85\ub839\uc5b4\uac00 \uc885\ub8cc\ub418\uba74 \ubcc0\uc218\uac00 \uc0ac\ub77c\uc9d0)
\ub2e4\ub9cc, \ub108\ubb34 \ub9ce\uc740 \uc804\uc5ed \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \uc6a9\ub7c9\uc774 \ucee4\uc9c0\uace0 \ub290\ub824\uc9c4\ub2e4\ub294 \ub2e8\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc790, \uc774\uc81c \uc140\uc774 \ubc14\ub00c\ub294 \ubd80\ubd84\uc744 \uc9c0\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
\uba85\ub839\uc5b4 \uc785\ub825\ucc3d \uc704\uc5d0 (\uc77c\ubc18)\uc774\ub77c\uace0 \ub418\uc5b4\uc788\ub294 \ubd80\ubd84\uc758 \uc120\ud0dd\ucc3d\uc744 \ub20c\ub7ec\uc11c Worksheet\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.
\uadf8\ub7ec\uba74 \uc606\uc5d0 (\uc120\uc5b8)\uc774\ub77c\uace0 \ub418\uc5b4 \uc788\ub294 \uc120\ud0dd\ucc3d\uc774 \uc790\ub3d9\uc73c\ub85c SelectionChange\ub85c \ubc14\ub00c\uba74\uc11c \ubc11\uc5d0 Private \uba85\ub839\uc5b4 \uad6c\ubb38\uc774 \uc0dd\uae30\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.
(\ub9cc\uc57d (\uc120\uc5b8)\uc774 \uadf8\ub300\ub85c \uc788\uac70\ub098, \ub2e4\ub978 \uba85\ub839\uc5b4\uac00 \ub098\uc628\ub2e4\uba74, SeletionChange\ub97c \uc120\ud0dd\ud574 \uc8fc\uc138\uc694.)<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\uc704\uc640 \uac19\uc740 \ucc3d\uc774 \ub098\uc628\ub2e4\uba74 \uc77c\ub2e8 \uc81c\ub300\ub85c \ub418\uace0 \uc788\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc77c\ub2e8 \uc140\uc774 \ubc14\ub00c\uba74, \ud604\uc7ac \uc140\uc744 \uc5b4\ub5bb\uac8c \ud45c\ud604\ud558\ub294\uc9c0 \uc784\uc2dc\ub85c \ub2e4\uc74c\uacfc \uac19\uc774 \ubb38\uad6c \uc785\ub825\ud574\uc11c \ud14c\uc2a4\ud2b8 \ud574\ubcf4\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n\n

MsgBox “Rows : ” & Target.Row & ” \/ Columns : ” & Target.Column<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\uc785\ub825\ud558\uc168\uc73c\uba70, \uc5d1\uc140 \uc2dc\ud2b8\ub85c \uac00\uc154\uc11c \ub9c8\uc6b0\uc2a4\ub85c \uc5ec\uae30\uc800\uae30 \ub20c\ub7ec \ubcf4\uc2dc\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ucc3d\uc774 \ub728\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

C5\uac00 \uc120\ud0dd\ub418\uc5c8\uc8e0. \ud589\uc740 5\uc774\uba70, \uc5f4\uc740 C\uc774\ub2c8\uae4c 3\uc785\ub2c8\ub2e4.
\uc815\ud655\ud558\uac8c \uc9c0\uae08 \uc120\ud0dd\ud55c \uc140\uc758 \uac12\uc774 \ub098\uc624\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

\ub2e4\ub9cc, \uc800\ud76c\ub294 \uc774\uc804\uc5d0 \uc120\ud0dd\ud55c \uc140\uc5d0 \uac12\uc774 \ubc14\ub00c\uc5c8\ub294\uc9c0 \ud655\uc778\ud574\uc57c \ud558\ubbc0\ub85c, \uc774\uc804 \uc140\uc744 \ub098\ud0c0\ub0bc \uc218 \uc788\ub3c4\ub85d \ubcc0\uc218\ub97c \uc774\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.
\uc989, \ud589\uacfc \uc5f4\uc758 \ubc88\ud638\ub97c \ubcc0\uc218\ub85c \uc9c0\uc815\ud558\uc5ec, \uc774\uc804\uc140\uc744 \ub098\ud0c0\ub0bc \uac83\uc785\ub2c8\ub2e4.
\ub2e4\uc74c\uacfc \uac19\uc774 \uc785\ub825\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

MsgBox “Privious – Rows : ” & r & ” \/ Columns : ” & c & Chr(13) & Chr(10) & “current – Rows : ” & Target.Row & ” \/ Columns : ” & Target.Column<\/p>\n\n\n\n

\uc911\uac04\uc5d0 chr(13) & chr(10)\uc740 \uc904\uc744 \ubc14\uafb8\ub294 \uba85\ub839\uc5b4 \uc785\ub2c8\ub2e4.
\ub2e4\uc74c\uacfc \uac19\uc774 \ub41c \uac83\uc744 \ud655\uc778\ud558\uc168\uc73c\uba74, \ub610\ub2e4\uc2dc \uc5d1\uc140\uc744 \uc774\ub3d9\ud574 \ubcf4\uc138\uc694.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\ucc98\uc74c \uc774\ub3d9\uc2dc\uc5d0\ub294 \uc774\uc804 \uc140\uc758 \uc704\uce58\uac00 \uc81c\ub300\ub85c \ub098\uc624\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.
\ub2f9\uc5f0\ud788 \uac12\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\uc558\uc73c\ub2c8\uae4c\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

\ud558\uc9c0\ub9cc 2\ubc88\uc9f8\ubd80\ud130\ub294 \uc774\uc804\uc140\uacfc \ud604\uc7ac \uc140\uc744 \uc815\ud655\ud558\uac8c \ub098\ud0c0\ub0b4\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\uba54\uc138\uc9c0\ucc3d\uc744 \ub744\uc6b0\uace0 r\uacfc c\uc758 \uac12\uc744 \ubc14\uafb8\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc989 \uc774\uc804\uc140\uc744 \ud655\uc778\ud558\uae30 \uc704\ud574\uc11c\ub294 r\uacfc c\uc758 \uac12\uc744 \uc9c0\uc815\ud558\uae30 \uc774\uc804\uc5d0 \ubaa8\ub4e0 \uba85\ub839\uc5b4\uac00 \uc885\ub8cc\ub418\uc5b4\uc57c \ud55c\ub2e4\ub294 \ub73b\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc790 \uc774\uc81c \ud544\uc694\ud55c \ub0b4\uc6a9\uc744 \ucc44\uc6cc\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
\ud544\uc694\ud55c \uc870\uac74\uc740 2\uac00\uc9c0\uc785\ub2c8\ub2e4.
\uccab\ubc88\uc9f8\ub294 \uc774\uc804 \uc140\uc774 \ucd5c\uc0c1\ub2e8\uc758 \uc81c\ubaa9\uc774 \uc544\ub2c8\uc5b4\uc57c \ud558\uba70, \ub450\ubc88\uc9f8\ub294 A\uc5f4\uacfc E\uc5f4\uc774 \uc544\ub2c8\uc5b4\uc57c \ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc81c\ubaa9\uc140\uc5d0 \ub0b4\uc6a9\uc774 \uc788\ub2e4\uace0, No.\uc640 \uc794\uc561\uc5d0 \ub2e4\ub978 \uae00\uc790\ub97c \ub123\uc5b4\ubc84\ub9ac\uba74 \ud070\uc77c \ub098\uaca0\uc8e0.
\uadf8\ub9ac\uace0 A\uc5f4\uacfc E\uc5f4\uc740 \uc218\uc2dd\uc774 \ub4e4\uc5b4\uac00\uc57c \ud558\ub294\ub370 \uc5ec\uae30\uc5d0 \ub2e4\ub978 \uac12\uc744 \ub123\uc5b4\ub3c4 \uc548\ub418\uaca0\uc8e0.
\uadf8\ub7f0 \uac83\uc785\ub2c8\ub2e4. \u314e\u314e\u314e<\/p>\n\n\n\n

\ub2e4\uc74c\uacfc \uac19\uc774 \ub0b4\uc6a9 \uc785\ub825\ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\ub9e8 \uc704\uc640 \ub450\ubc88\uc9f8 IF\ubb38\uc740 \uccab\ubc88\uc9f8 \uc2e4\ud589\ud560 \ub54c, \ud589\uacfc \uc5f4\uac12\uc774 \uc5c6\uc73c\uba74 \uc624\ub958\uac00 \ub098\uae30 \ub54c\ubb38\uc5d0 \uae30\ubcf8\uac12\uc73c\ub85c 1\uc744 \ub123\uc5b4 \uc8fc\uc5c8\uc2b5\ub2c8\ub2e4.
\uc138\ubc88\uc9f8\uc758 IF\ubb38\uc740 \uc774\uc804 \uc140\uc758 \ud589 \uac12\uc774 1\ubcf4\ub2e4 \ucee4\uc57c \ud558\uace0, \uc5f4 \uac12\uc774 1(A\uc5f4)\uacfc 5(E\uc5f4)\uc774 \uc544\ub2c8\uba74\uc11c \uc774\uc804 \uc140 \uac12\uc774 \uacf5\ubc31\uc774 \uc544\ub2d0 \uacbd\uc6b0 \uc2e4\ud589\ud558\ub77c\ub294 \ub0b4\uc6a9\uc785\ub2c8\ub2e4.
\uc989, 1\ud589\uc774\uac70\ub098, A\uc5f4\uc774\uac70\ub098, E\uc5f4\uc774\uba74 \uc2e4\ud589\uc744 \ud558\uc9c0 \uc54a\uace0, \ub610\ud55c \uc140 \uac12\uc774 \ubcc0\uacbd\ub418\uc9c0 \uc54a\uc558\uc73c\uba74 \uc2e4\ud589\ud558\uc9c0 \uc54a\ub3c4\ub85d \uc124\uacc4\ud55c \uac83\uc785\ub2c8\ub2e4.
\ub124\ubc88\uc7ac IF\ubb38\uc740 r\uc774 2\uc77c \uacbd\uc6b0\uc778\ub370\uc694, \uc989 \uc774\uc804 \ud569\uacc4\uc561\uc774 \uc5c6\uc744 \uacbd\uc6b0\uc5d0\ub294 \uc785\uae08\uac12\uc740 \ub354\ud558\uace0 \ucd9c\uae09\uac12\uc740 \ube7c\uace0, 2\uc774\uc0c1\uc77c \uacbd\uc6b0 \ud569\uacc4\uc561\uc5d0\uc11c \uc785\uae08\uac12\uc740 \ub354\ud558\uace0 \ucd9c\uae08\uac12\uc740 \ube7c\ub77c\ub294 \uba85\ub839\uc5b4\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc774\ub807\uac8c \ud558\uba74 \uac04\ub2e8\ud55c \uac00\uacc4\ubd80\uc758 \uc218\uc2dd \uc790\ub3d9 \uc785\ub825\uc740 \ub05d\ub0ac\uc2b5\ub2c8\ub2e4.
\ud14c\uc2a4\ud2b8 \ud574\ubcf4\ub3c4\ub85d \ud560\uaed8\uc694.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

No.\uc640 \uc794\uc561\uc5d0 \uc790\ub3d9\uc73c\ub85c \uc218\uc2dd\uc774 \uc785\ub825\ub418\uc5c8\ub098\uc694?
\uc0dd\uac01\ubcf4\ub2e4 \uc5b4\ub835\uc9c4 \uc54a\uc8e0?
\uc77c\ub2e8 \uc774 \uc815\ub3c4\uc5d0\uc11c \uc911\uac04 \uc800\uc7a5\uc744 \ud558\uaca0\uc2b5\ub2c8\ub2e4.
\uc5ec\uae30\uc11c \uc8fc\uc758\ud560 \uc810\uc774 \ud558\ub098\uac00 \ub354 \uc788\uc2b5\ub2c8\ub2e4.
\ubc14\ub85c…. \uc800\uc7a5 \ud30c\uc77c\ud615\uc2dd\uc744 \ub9e4\ud06c\ub85c\ud0c0\uc785(.xlsm)\uc73c\ub85c \ud574\uc57c \ub41c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\ub9e4\ud06c\ub85c \uc0ac\uc6a9 \ud1b5\ud569\ubb38\uc11c\ub85c \uc800\uc7a5\ud558\uc9c0 \uc54a\uc73c\uba74, \ub2e4\uc74c\uc5d0 \uc5f4\ub54c \ub9e4\ud06c\ub85c\uac00 \uc0ac\ub77c\uc838 \uc788\ub294 \uae30\uc801\uc744 \ubcf4\uc2dc\uac8c \ub420 \uac83\uc785\ub2c8\ub2e4. \u314e\u314e\u314e\u314e
\uc5ec\uae30\uae4c\uc9c0 \uc791\uc5c5\ud55c \ud30c\uc77c\uc740 \uc544\ub798\uc640 \uac19\uc774 \uc62c\ub824\ub450\uc5c8\uc73c\ub2c8 \ucc38\uc870\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n\n

\uac00\uacc4\ubd80<\/a>\ub2e4\uc6b4\ub85c\ub4dc<\/a><\/div>\n\n\n\n

<\/p>\n\n\n\n

\uc790 \uc624\ub298\uc740 \uc5ec\uae30\uae4c\uc9c0 \uc785\ub2c8\ub2e4.
\uac04\ub2e8\ud55c VBA\uc778\ub370\ub3c4, \ucc98\uc74c \uc124\uba85\ud558\ub2c8\uae4c \uc2dc\uac04\uc774 \uae38\uc5b4\uc9c0\ub124\uc694.<\/p>\n\n\n\n

\uc624\ub298\ub3c4 \uc88b\uc740 \ud558\ub8e8 \ubcf4\ub0b4\uc138\uc694.<\/p>\n\n\n

Excel<\/a>, <\/span>VBA<\/a>, <\/span>\uac00\uacc4\ubd80<\/a>, <\/span>\ub9e4\ud06c\ub85c<\/a>, <\/span>\uc5d1\uc140<\/a>, <\/span>\uc790\ub3d9\uc218\uc2dd\uac78\uae30<\/a><\/div>\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc548\ub155\ud558\uc138\uc694 \ucc44\ub791\uc774 \uc544\ube60 \ud504\ub9ac\uc544\uc785\ub2c8\ub2e4. \uc624\ub298\uc740 \uc5d1\uc140\uc744 \uc0ac\uc6a9\ud574\uc11c \uac00\uacc4\ubd80\ub97c \ub9cc\ub4e4\uc5b4 \ubcfc\uac81\ub2c8\ub2e4.\uadf8\ub0e5 \uc5d1\uc140\uc744 \uc0ac\uc6a9\ud574\uc11c \ub9cc\ub4dc\ub294 \uac70\ub77c\uba74 \ub204\uad6c\ub77c\ub3c4 \ub9cc\ub4e4\uc218 \uc788\uaca0\uc8e0 ^^\uc800\ud76c\ub294 VBA\uac00 \ucd94\uac00\ub41c \uac00\uacc4\ubd80\ub97c \ub9cc\ub4e4\uac81\ub2c8\ub2e4. VBA\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \uac04\ub2e8\ud558\uac8c\ub294 \uc790\ub3d9\uc73c\ub85c \uc218\uc2dd\uc744 \ub123\uac8c \ub9cc\ub4e4 \uc218 \ub3c4 \uc788\uad6c\uc694,\uac00\uacc4\ubd80 \uc785\ub825\ud560 \ub0b4\uc6a9\uc744 \ud31d\uc5c5\uc73c\ub85c \ub744\uc6cc\uc11c \uc785\ub825\ud558\uac8c \ub9cc\ub4e4\uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.\ub450\uac00\uc9c0 \ubaa8\ub450 VBA\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc774\ub77c\uace0 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uba3c\uc800 VBA\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc790\ub3d9\uc73c\ub85c \uc218\uc2dd\uc744 \ub123\ub294 \ubc29\ubc95\uc744 \uc54c\ub824\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. \uc6b0\uc120, \uac00\uacc4\ubd80 \ud2c0\uc744 \uc7a1\uc544\uc57c\uaca0\uc8e0.\ud2c0\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \uc7a1\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc2ec\ud50c\ud558\uc8e0? \uc77c\ubc18\uc801\uc73c\ub85c \ub9ce\uc774 \ubcfc \uc218 \uc788\ub294 \ud615\ud0dc\ub85c \uc7a1\uc558\uc5b4\uc694.\uc790 \uc774\uc911\uc5d0\uc11c \uc790\ub3d9 \uc218\uc2dd\uc744 \uac78 \uc218 \uc788\uc744 \ub9cc\ud55c \uacf3\uc740 \ucd1d 2\uacf3\uc785\ub2c8\ub2e4.No.\uc640 \uc794\uc561\uc785\ub2c8\ub2e4.\ub098\uba38\uc9c0\ub294 \ub2e4 \uc785\ub825\ud574\uc57c\uc9c0\ub9cc \ub418\ub294 \ud56d\ubaa9\ub4e4\uc774\uc8e0. VBA\ub97c \uac78 \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. – \uc77c\uc790, \uc785\uae08, \ucd9c\uae08, \ube44\uace0 \uc911\uc5d0 \uac12\uc774 \uc785\ub825\ub418\uba74 \uc218\uc2dd\uc744 \uc790\ub3d9 \uc785\ub825\ud55c\ub2e4. \uc77c\ub2e8 \uc6b0\ub9ac\uac00 \uc54c\uc544\uc57c \ud558\ub294 \ub370\uc774\ud130\ub294 2\uac00\uc9c0\uc785\ub2c8\ub2e4.\uc140\uc744 \uc774\ub3d9\ud588\uc744 \ub54c, \uc774\uc804\uc758 \uc140\uc758 Row\uac12\uacfc Column\uac12\uc774\uc8e0. \uc77c\ub2e8 \uc774\uc804 \uc140\uc758 Row\uac12\uacfc Column\uac12\uc744 \uc785\ub825\ud560 \uc804\uc5ed \ubcc0\uc218\ub97c \uc9c0\uc815\ud560 \uac83\uc785\ub2c8\ub2e4. \uc77c\ub2e8 Alt+F11\uc744 \ub20c\ub7ec\uc11c VBA \ucc3d\uc744 \ub744\uc6b0\uc138\uc694. \uc774\ub807\uac8c \ubcf4\uc774\uba74\uc11c Sheet1\uc774 \uc120\ud0dd\ub418\uc5b4 \uc9c4\uac83\uc774 \ubcf4\uc785\ub2c8\ub2e4. \uc606\uc5d0 \uce78\uc5d0\ub2e4\uac00 \ub2e4\uc74c\uacfc \uac19\uc774 \uc785\ub825\ud569\ub2c8\ub2e4. Dim r, c As Integer Dim\uc740 \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\ub294 \uad6c\uc808\uc785\ub2c8\ub2e4.\ubcc0\uc218\uc758 \uc774\ub984\uc740 r\uacfc c\uc774\uba70, \ud0c0\uc785\uc740 \uc815\uc218\uc785\ub2c8\ub2e4. r\uc740 Rows\uc758 \uc57d\uc790\uc774\uba70, c\ub294 Column\uc758 \uc57d\uc790\uc785\ub2c8\ub2e4.\uc774\ub807\uac8c \ubcc0\uc218\uba85\uc740 \uc790\uc2e0\uc774 \uc54c\uc544\ubcf4\uae30 \uc26c\uc6b4 \uac83\uc73c\ub85c \ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.\ub2e4\ub9cc, \ub108\ubb34 \ubcc0\uc218\uba85\uc744 \ub514\ud14c\uc77c\ud558\uac8c \uc7a1\uc73c\uc2dc\uba74 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\uc27d\uac8c \ub9d0\ud574 \ubcc0\uc218\ub97c rows\ub85c \uc7a1\uc544\ubc84\ub9ac\uba74, VBA \uba85\ub839\uc5b4 \uc911\uc5d0 \uc788\ub294 Rows\ub77c\ub294 \uba85\ub839\uc5b4\uc640 \uc911\ucca9\uc774 \ub418\uc5b4\ubc84\ub9ac\uae30 \ub54c\ubb38\uc5d0 \uad6c\uc808 \uc624\ub958\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.\uadf8\ub798\uc11c row_check\ub098, r \ub4f1 \ub2e8\uc5b4+\ucd94\uac00\ubb38\uad6c \ub610\ub294 \uc644\uc804 \uc57d\uc790\uc758 \ud615\ud0dc\ub85c \uc7a1\uc73c\uc2dc\ub294\uac8c \uc88b\uc2b5\ub2c8\ub2e4.\uc804 \uae38\uac8c \uc4f0\ub294\uac8c \uc2eb\uc5b4\uc11c \uadf8\ub0e5 1\uae00\uc790\ub85c \ud241\uccd0\uc694 \u314e\u314e\u314e\u314e. public\ub098 private \ubb38\uad6c \uc548\uc774 \uc544\ub2cc \ubc16\uc5d0 Dim\uc73c\ub85c \uc120\uc5b8\ud55c \ubcc0\uc218\uc758 \uacbd\uc6b0 \ubaa8\ub4e0 \ud558\uc704 \uc9d1\ub2e8\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4\ub294 \uc7a5\uc810\uc774 \uc788\uc73c\uba70,\ud558\ub098\uc758 \uba85\ub839\uc5b4 \uc9d1\ub2e8\uc774 \uc644\ub8cc\ub418\uc5b4\ub3c4 \ud574\ub2f9 \ubcc0\uc218\ub294 \uc720\uc9c0\ub41c\ub2e4\ub294 \uc7a5\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4.(public\ub098 private \uad6c\uc808\uc548\uc758 \ubcc0\uc218\ub294 \ud574\ub2f9 \uba85\ub839\uc5b4\uac00 \uc885\ub8cc\ub418\uba74 \ubcc0\uc218\uac00 \uc0ac\ub77c\uc9d0)\ub2e4\ub9cc, \ub108\ubb34 \ub9ce\uc740 \uc804\uc5ed \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \uc6a9\ub7c9\uc774 \ucee4\uc9c0\uace0 \ub290\ub824\uc9c4\ub2e4\ub294 \ub2e8\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc790, \uc774\uc81c \uc140\uc774 \ubc14\ub00c\ub294 \ubd80\ubd84\uc744 \uc9c0\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.\uba85\ub839\uc5b4 \uc785\ub825\ucc3d \uc704\uc5d0 (\uc77c\ubc18)\uc774\ub77c\uace0 \ub418\uc5b4\uc788\ub294 \ubd80\ubd84\uc758 \uc120\ud0dd\ucc3d\uc744 \ub20c\ub7ec\uc11c Worksheet\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.\uadf8\ub7ec\uba74 \uc606\uc5d0 (\uc120\uc5b8)\uc774\ub77c\uace0 \ub418\uc5b4 \uc788\ub294 \uc120\ud0dd\ucc3d\uc774 \uc790\ub3d9\uc73c\ub85c SelectionChange\ub85c \ubc14\ub00c\uba74\uc11c \ubc11\uc5d0 Private \uba85\ub839\uc5b4 \uad6c\ubb38\uc774 \uc0dd\uae30\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.(\ub9cc\uc57d (\uc120\uc5b8)\uc774 \uadf8\ub300\ub85c \uc788\uac70\ub098, \ub2e4\ub978 \uba85\ub839\uc5b4\uac00 \ub098\uc628\ub2e4\uba74, SeletionChange\ub97c \uc120\ud0dd\ud574 \uc8fc\uc138\uc694.) \uc704\uc640 \uac19\uc740 \ucc3d\uc774 \ub098\uc628\ub2e4\uba74 \uc77c\ub2e8 \uc81c\ub300\ub85c \ub418\uace0 \uc788\ub294 \uac83\uc785\ub2c8\ub2e4. \uc77c\ub2e8 \uc140\uc774 \ubc14\ub00c\uba74, \ud604\uc7ac \uc140\uc744 \uc5b4\ub5bb\uac8c \ud45c\ud604\ud558\ub294\uc9c0 \uc784\uc2dc\ub85c \ub2e4\uc74c\uacfc \uac19\uc774 \ubb38\uad6c \uc785\ub825\ud574\uc11c \ud14c\uc2a4\ud2b8 \ud574\ubcf4\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4. MsgBox “Rows : ” & Target.Row & ” \/ Columns : ” & Target.Column \uc785\ub825\ud558\uc168\uc73c\uba70, \uc5d1\uc140 \uc2dc\ud2b8\ub85c \uac00\uc154\uc11c \ub9c8\uc6b0\uc2a4\ub85c \uc5ec\uae30\uc800\uae30 \ub20c\ub7ec \ubcf4\uc2dc\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ucc3d\uc774 \ub728\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. C5\uac00 \uc120\ud0dd\ub418\uc5c8\uc8e0. \ud589\uc740 5\uc774\uba70, \uc5f4\uc740 C\uc774\ub2c8\uae4c 3\uc785\ub2c8\ub2e4.\uc815\ud655\ud558\uac8c \uc9c0\uae08 \uc120\ud0dd\ud55c \uc140\uc758 \uac12\uc774 \ub098\uc624\uac8c \ub429\ub2c8\ub2e4. \ub2e4\ub9cc, \uc800\ud76c\ub294 \uc774\uc804\uc5d0 \uc120\ud0dd\ud55c \uc140\uc5d0 \uac12\uc774 \ubc14\ub00c\uc5c8\ub294\uc9c0 \ud655\uc778\ud574\uc57c \ud558\ubbc0\ub85c, \uc774\uc804 \uc140\uc744 \ub098\ud0c0\ub0bc \uc218 \uc788\ub3c4\ub85d \ubcc0\uc218\ub97c \uc774\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.\uc989, \ud589\uacfc \uc5f4\uc758 \ubc88\ud638\ub97c \ubcc0\uc218\ub85c \uc9c0\uc815\ud558\uc5ec, \uc774\uc804\uc140\uc744 \ub098\ud0c0\ub0bc \uac83\uc785\ub2c8\ub2e4.\ub2e4\uc74c\uacfc \uac19\uc774 \uc785\ub825\ud558\uaca0\uc2b5\ub2c8\ub2e4. MsgBox “Privious – Rows : ” & r & ” \/ Columns : ” & c & Chr(13) & Chr(10) & “current – Rows : ” & Target.Row & ” \/ Columns : ” & Target.Column \uc911\uac04\uc5d0 chr(13) & chr(10)\uc740 \uc904\uc744 \ubc14\uafb8\ub294 \uba85\ub839\uc5b4 \uc785\ub2c8\ub2e4.\ub2e4\uc74c\uacfc \uac19\uc774 \ub41c \uac83\uc744 \ud655\uc778\ud558\uc168\uc73c\uba74, \ub610\ub2e4\uc2dc \uc5d1\uc140\uc744 \uc774\ub3d9\ud574 \ubcf4\uc138\uc694. \ucc98\uc74c \uc774\ub3d9\uc2dc\uc5d0\ub294 \uc774\uc804 \uc140\uc758 \uc704\uce58\uac00 \uc81c\ub300\ub85c \ub098\uc624\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.\ub2f9\uc5f0\ud788 \uac12\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\uc558\uc73c\ub2c8\uae4c\uc785\ub2c8\ub2e4. \ud558\uc9c0\ub9cc 2\ubc88\uc9f8\ubd80\ud130\ub294 \uc774\uc804\uc140\uacfc \ud604\uc7ac \uc140\uc744 \uc815\ud655\ud558\uac8c \ub098\ud0c0\ub0b4\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.\uba54\uc138\uc9c0\ucc3d\uc744 \ub744\uc6b0\uace0 r\uacfc c\uc758 \uac12\uc744 \ubc14\uafb8\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uc989 \uc774\uc804\uc140\uc744 \ud655\uc778\ud558\uae30 \uc704\ud574\uc11c\ub294 r\uacfc c\uc758 \uac12\uc744 \uc9c0\uc815\ud558\uae30 \uc774\uc804\uc5d0 \ubaa8\ub4e0 \uba85\ub839\uc5b4\uac00 \uc885\ub8cc\ub418\uc5b4\uc57c \ud55c\ub2e4\ub294 \ub73b\uc785\ub2c8\ub2e4. \uc790 \uc774\uc81c \ud544\uc694\ud55c \ub0b4\uc6a9\uc744 \ucc44\uc6cc\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.\ud544\uc694\ud55c \uc870\uac74\uc740 2\uac00\uc9c0\uc785\ub2c8\ub2e4.\uccab\ubc88\uc9f8\ub294 \uc774\uc804 \uc140\uc774 \ucd5c\uc0c1\ub2e8\uc758 \uc81c\ubaa9\uc774 \uc544\ub2c8\uc5b4\uc57c \ud558\uba70, \ub450\ubc88\uc9f8\ub294 A\uc5f4\uacfc E\uc5f4\uc774 \uc544\ub2c8\uc5b4\uc57c \ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uc81c\ubaa9\uc140\uc5d0 \ub0b4\uc6a9\uc774 \uc788\ub2e4\uace0, No.\uc640 \uc794\uc561\uc5d0 \ub2e4\ub978 \uae00\uc790\ub97c \ub123\uc5b4\ubc84\ub9ac\uba74 \ud070\uc77c \ub098\uaca0\uc8e0.\uadf8\ub9ac\uace0 A\uc5f4\uacfc E\uc5f4\uc740 \uc218\uc2dd\uc774 \ub4e4\uc5b4\uac00\uc57c \ud558\ub294\ub370 \uc5ec\uae30\uc5d0 \ub2e4\ub978 \uac12\uc744 \ub123\uc5b4\ub3c4 \uc548\ub418\uaca0\uc8e0.\uadf8\ub7f0 \uac83\uc785\ub2c8\ub2e4. \u314e\u314e\u314e \ub2e4\uc74c\uacfc \uac19\uc774 \ub0b4\uc6a9 \uc785\ub825\ud558\uaca0\uc2b5\ub2c8\ub2e4. \ub9e8 \uc704\uc640 \ub450\ubc88\uc9f8 IF\ubb38\uc740 \uccab\ubc88\uc9f8 \uc2e4\ud589\ud560 \ub54c, \ud589\uacfc \uc5f4\uac12\uc774 \uc5c6\uc73c\uba74 \uc624\ub958\uac00 \ub098\uae30 \ub54c\ubb38\uc5d0 \uae30\ubcf8\uac12\uc73c\ub85c 1\uc744 \ub123\uc5b4 \uc8fc\uc5c8\uc2b5\ub2c8\ub2e4.\uc138\ubc88\uc9f8\uc758 IF\ubb38\uc740 \uc774\uc804 \uc140\uc758 \ud589 \uac12\uc774 1\ubcf4\ub2e4 \ucee4\uc57c \ud558\uace0, \uc5f4 \uac12\uc774 1(A\uc5f4)\uacfc 5(E\uc5f4)\uc774 \uc544\ub2c8\uba74\uc11c \uc774\uc804 \uc140 \uac12\uc774 \uacf5\ubc31\uc774 \uc544\ub2d0 \uacbd\uc6b0 \uc2e4\ud589\ud558\ub77c\ub294 \ub0b4\uc6a9\uc785\ub2c8\ub2e4.\uc989, 1\ud589\uc774\uac70\ub098, A\uc5f4\uc774\uac70\ub098, E\uc5f4\uc774\uba74 \uc2e4\ud589\uc744 \ud558\uc9c0 \uc54a\uace0, \ub610\ud55c \uc140 \uac12\uc774 \ubcc0\uacbd\ub418\uc9c0 \uc54a\uc558\uc73c\uba74 \uc2e4\ud589\ud558\uc9c0 \uc54a\ub3c4\ub85d \uc124\uacc4\ud55c \uac83\uc785\ub2c8\ub2e4.\ub124\ubc88\uc7ac IF\ubb38\uc740 r\uc774 2\uc77c \uacbd\uc6b0\uc778\ub370\uc694, \uc989 \uc774\uc804 \ud569\uacc4\uc561\uc774 \uc5c6\uc744 \uacbd\uc6b0\uc5d0\ub294 \uc785\uae08\uac12\uc740 \ub354\ud558\uace0 \ucd9c\uae09\uac12\uc740 \ube7c\uace0, 2\uc774\uc0c1\uc77c \uacbd\uc6b0 \ud569\uacc4\uc561\uc5d0\uc11c \uc785\uae08\uac12\uc740 \ub354\ud558\uace0 \ucd9c\uae08\uac12\uc740 \ube7c\ub77c\ub294 \uba85\ub839\uc5b4\uc785\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \uac04\ub2e8\ud55c \uac00\uacc4\ubd80\uc758 \uc218\uc2dd \uc790\ub3d9 \uc785\ub825\uc740 \ub05d\ub0ac\uc2b5\ub2c8\ub2e4.\ud14c\uc2a4\ud2b8 \ud574\ubcf4\ub3c4\ub85d \ud560\uaed8\uc694. No.\uc640 \uc794\uc561\uc5d0 \uc790\ub3d9\uc73c\ub85c \uc218\uc2dd\uc774 \uc785\ub825\ub418\uc5c8\ub098\uc694?\uc0dd\uac01\ubcf4\ub2e4 \uc5b4\ub835\uc9c4 \uc54a\uc8e0?\uc77c\ub2e8 \uc774 \uc815\ub3c4\uc5d0\uc11c \uc911\uac04 \uc800\uc7a5\uc744 \ud558\uaca0\uc2b5\ub2c8\ub2e4.\uc5ec\uae30\uc11c \uc8fc\uc758\ud560 \uc810\uc774 \ud558\ub098\uac00 \ub354 \uc788\uc2b5\ub2c8\ub2e4.\ubc14\ub85c…. \uc800\uc7a5 \ud30c\uc77c\ud615\uc2dd\uc744 \ub9e4\ud06c\ub85c\ud0c0\uc785(.xlsm)\uc73c\ub85c \ud574\uc57c \ub41c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \ub9e4\ud06c\ub85c \uc0ac\uc6a9 \ud1b5\ud569\ubb38\uc11c\ub85c \uc800\uc7a5\ud558\uc9c0 \uc54a\uc73c\uba74, \ub2e4\uc74c\uc5d0 \uc5f4\ub54c \ub9e4\ud06c\ub85c\uac00 \uc0ac\ub77c\uc838 \uc788\ub294 \uae30\uc801\uc744 \ubcf4\uc2dc\uac8c \ub420 \uac83\uc785\ub2c8\ub2e4. \u314e\u314e\u314e\u314e\uc5ec\uae30\uae4c\uc9c0 \uc791\uc5c5\ud55c \ud30c\uc77c\uc740 \uc544\ub798\uc640 \uac19\uc774 \uc62c\ub824\ub450\uc5c8\uc73c\ub2c8 \ucc38\uc870\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4. \uc790 \uc624\ub298\uc740 \uc5ec\uae30\uae4c\uc9c0 \uc785\ub2c8\ub2e4.\uac04\ub2e8\ud55c VBA\uc778\ub370\ub3c4, \ucc98\uc74c \uc124\uba85\ud558\ub2c8\uae4c \uc2dc\uac04\uc774 \uae38\uc5b4\uc9c0\ub124\uc694. \uc624\ub298\ub3c4 \uc88b\uc740 \ud558\ub8e8 \ubcf4\ub0b4\uc138\uc694.<\/p>\n","protected":false},"author":1,"featured_media":789,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[27],"tags":[142,177,197,178,141,198],"class_list":["post-776","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-27","tag-excel-2","tag-vba","tag-197","tag-178","tag-141","tag-198"],"_links":{"self":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=776"}],"version-history":[{"count":1,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/776\/revisions"}],"predecessor-version":[{"id":792,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/776\/revisions\/792"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/media\/789"}],"wp:attachment":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}