{"id":1665,"date":"2024-05-09T18:33:03","date_gmt":"2024-05-09T09:33:03","guid":{"rendered":"https:\/\/www.isa-school.net\/blog\/?p=1665"},"modified":"2024-07-22T19:55:09","modified_gmt":"2024-07-22T10:55:09","slug":"vba-excelvba02","status":"publish","type":"post","link":"https:\/\/www.isa-school.net\/blog\/vba-excelvba02\/","title":{"rendered":"\u3010\u30a8\u30af\u30bb\u30ebVBA\u3011\u6307\u5b9a\u7bc4\u56f2\u3092\u30b3\u30d4\u30fc&\u30da\u30fc\u30b9\u30c8\u3059\u308b"},"content":{"rendered":"\n

VBA\u306e\u8cc7\u683c\u53d6\u5f97\u3092\u5fdc\u63f4\u3059\u308b\u300c\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4ISA<\/a>\u300d\u30e9\u30a4\u30bf\u30fc\u30c1\u30fc\u30e0\u3067\u3059\u3002<\/p>\n\n\n\n

\u30a8\u30af\u30bb\u30eb\u3067\u65e5\u3005\u884c\u3046\u696d\u52d9\u30b3\u30d4\u30fc&\u30da\u30fc\u30b9\u30c8<\/span>\u3002\u7e70\u308a\u8fd4\u3057\u4f5c\u696d\u306fVBA\u306e\u6a5f\u80fd\u3092\u4f7f\u3048\u3070\u6642\u77ed<\/span>\u306b\u7e4b\u304c\u308a\u307e\u3059\u3002\u30de\u30af\u30ed\u3067\u306f\u5b9f\u73fe\u3067\u304d\u306a\u3044\u3053\u3068\u3082VBA\u3067\u306f\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n

\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4ISA\u306e\u8cc7\u6599\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\uff08\u7121\u6599\uff09<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n

\u30b3\u30d4\u30fc\u5143\u306e\u30c7\u30fc\u30bf\u7bc4\u56f2\u3092\u53d6\u5f97\u3059\u308b<\/h2>\n\n\n\n

\u30b3\u30d4\u30fc\u5143\u306e\u30c7\u30fc\u30bf\u7bc4\u56f2\u306e\u53d6\u5f97\u65b9\u6cd5\u3092\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<\/span><\/p>\n\n\n\n

Range\u30d7\u30ed\u30d1\u30c6\u30a3\u3067\u7bc4\u56f2\u3092\u53d6\u5f97\u3059\u308b<\/h3>\n\n\n\n

Range\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u4f7f\u3063\u3066\u8907\u6570\u306e\u30bb\u30eb\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n\n\n\n

\n

\u5358\u4e00\u30bb\u30eb\u306e\u53d6\u5f97\u3000Range(\u201cA1\u201d)\u3000\u2018A1\u3092\u53d6\u5f97
\u30bb\u30eb\u7bc4\u56f2\u306e\u53d6\u5f97\u3000Range(\u201cA1:C3\u201d)\u3000A1\u304b\u3089C3\u306e\u7bc4\u56f2\u3092\u53d6\u5f97
\u96e2\u308c\u305f\u30bb\u30eb\u3092\u53d6\u5f97 Range(\u201cA1,C3\u201d)\u3000A1\u3068C3\u3092\u53d6\u5f97
\u96e2\u308c\u305f\u30bb\u30eb\u3068\u7bc4\u56f2\u3092\u53d6\u5f97\u3000Range(\u201cA1,B2:C3\u201d)\u3000A1\u3068B2\u304b\u3089C3\u3092\u53d6\u5f97<\/p>\n<\/div>\n\n\n\n

\u6b63\u3057\u304f\u30bb\u30eb\u7bc4\u56f2\u3092\u53d6\u5f97\u3067\u304d\u3066\u3044\u308b\u304b\u3092\u78ba\u8a8d\u3057\u305f\u3044\u5834\u5408\u306b\u306f\u3001\u5f8c\u308d\u306bselect\u30e1\u30bd\u30c3\u30c9\u3092\u4ed8\u3051\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/span><\/p>\n\n\n\n

<\/i><\/div>
\n

Range(\u201cA1,B2:C4\u201d).Select<\/span><\/p>\n<\/div><\/div>\n\n\n\n

\u305d\u306e\u4ed6\u306eRange\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u7bc4\u56f2\u53d6\u5f97\u65b9\u6cd5<\/h3>\n\n\n\n

\u884c\u306e\u53d6\u5f97\u3000Range(“1:1”)\u30001\u884c\u76ee\u3092\u53d6\u5f97<\/span>
<\/span>\u884c\u306e\u53d6\u5f97\u3000Range(“1:3”)\u30001\uff5e3\u884c\u76ee\u3092\u53d6\u5f97<\/span>
<\/span>\u5217\u306e\u53d6\u5f97\u3000Range(“1:3”)\u3000A\uff5eC\u5217\u3092\u53d6\u5f97<\/span>
<\/span>\u540d\u524d\u306e\u53d6\u5f97\u3000Range(Data)\u3000Data\u3068\u3044\u3046\u540d\u524d\u306e\u30bb\u30eb\u7bc4\u56f2\u3092\u53d6\u5f97<\/span><\/p>\n\n\n\n

\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4ISA\u306eVBA\u8b1b\u5ea7\u3092\u4f53\u9a13\u3057\u3066\u307f\u308b\uff08\u7121\u6599\uff09<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n
\nhttps:\/\/www.isa-school.net\/blog\/vba-excelvba01\n<\/div><\/figure>\n\n\n
\n

\uff3c\u30001\u5206\u3067\u7533\u3057\u8fbc\u307f\u5b8c\u4e86 \uff0f<\/span><\/strong><\/p>\n

VBA\u8b1b\u5ea7\u306e\u4f53\u9a13\u30ec\u30c3\u30b9\u30f3\u3092\u7533\u3057\u8fbc\u3080<\/a><\/span><\/strong><\/p>\n<\/div>\n\n\n

\u30b3\u30d4\u30fc\uff06\u30da\u30fc\u30b9\u30c8\u3059\u308b<\/h2>\n\n\n\n

\u30b3\u30d4\u30fc\u5143\u306e\u30c7\u30fc\u30bf\u7bc4\u56f2\u3092\u53d6\u5f97\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u306e\u3067\u3001\u30b3\u30d4\u30fc&\u30da\u30fc\u30b9\u30c8\u3092\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/span><\/p>\n\n\n\n

Copy\u30e1\u30bd\u30c3\u30c9<\/h3>\n\n\n\n

\u9078\u629e\u7bc4\u56f2\u3092\u30b3\u30d4\u30fc\u3057\u305f\u3044\u5834\u5408\u306b\u306f\u3001Copy\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3044\u307e\u3059\u3002\u30b3\u30d4\u30fc\u5148\u306f\u5f15\u6570Destination\u3092\u4f7f\u3063\u3066\u6307\u5b9a\u3057\u307e\u3059\u3002<\/span><\/p>\n\n\n\n

<\/i><\/div>
\n

\u30b3\u30d4\u30fc\u5143\u30aa\u30d6\u30b8\u30a7\u30af\u30c8.Copy Destination:\uff1d\u30b3\u30d4\u30fc\u5148\u30bb\u30eb\u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/span><\/p>\n<\/div><\/div>\n\n\n\n


\u30bb\u30ebA1\u3092\u30bb\u30ebC3\u306b\u30b3\u30d4\u30fc\u3057\u3066\u307f\u307e\u3059\u3002<\/span><\/p>\n\n\n\n

\n

Range(“A1”).Copy Destination:= Range (“C3”)<\/span><\/p>\n<\/div>\n\n\n\n

Copy\u30e1\u30bd\u30c3\u30c9\u306e\u5f15\u6570\u306fDestination\u3060\u3051\u306a\u306e\u3067\u300cDestination:=\u300d\u306f\u7701\u7565\u53ef\u80fd\u3067\u3059\u3002
\u540c\u3058\u7d50\u679c\u306b\u306a\u308a\u307e\u3059\u3002<\/span><\/p>\n\n\n\n

\n

Range(“A1”).Copy Range (“C3”)<\/span><\/p>\n<\/div>\n\n\n\n

\u30d1\u30bd\u30b3\u30f3\u6559\u5ba4ISA\u306eVBA\u8b1b\u5ea7\u3092\u4f53\u9a13\u3057\u3066\u307f\u308b\uff08\u7121\u6599\uff09<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n

PasteSpecial\u30e1\u30bd\u30c3\u30c9<\/h3>\n\n\n\n

\u5f62\u5f0f\u3092\u9078\u629e\u3057\u3066\u8cbc\u308a\u4ed8\u3051\u305f\u3044\u3068\u304d\u306fPasteSpecial<\/span>\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3044\u307e\u3059\u3002\uff08\u4f8b\u5916\u7684\u306b\u30ea\u30f3\u30af\u8cbc\u308a\u4ed8\u3051\u306fPaste\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3044\u307e\u3059\uff09<\/span><\/p>\n\n\n\n

\u8cbc\u308a\u4ed8\u3051\u306e\u5f62\u5f0f\u306f\u5f15\u6570Paste\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002
A1\u304b\u3089C3\u306b\u5024\u8cbc\u308a\u4ed8\u3051\u3092\u884c\u3063\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/span><\/p>\n\n\n\n

    \n
  1. \u30b3\u30d4\u30fc\u5143\u3092\u53d6\u5f97\u3057\u3066\u3001Copy\u30e1\u30bd\u30c3\u30c9\u3067\u30b3\u30d4\u30fc\u3092\u3068\u308b<\/span><\/li>\n\n\n\n
  2. \u30b3\u30d4\u30fc\u5148\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306bPasteSpecial\u30e1\u30bd\u30c3\u30c9\u3067\u5f62\u5f0f\u3092\u9078\u629e\u3057\u3066\u8cbc\u308a\u4ed8\u3051\u308b\u3068\u3044\u3046\u624b\u9806\u3067\u884c\u3044\u307e\u3059\u3002\uff08\u30a8\u30af\u30bb\u30eb\u306e\u64cd\u4f5c\u3092\u30a4\u30e1\u30fc\u30b8\u3057\u3066\u4e0b\u3055\u3044\uff09<\/span><\/li>\n<\/ol>\n\n\n\n

    \u30b3\u30fc\u30c9\u306f2\u884c\u3067\u3059\u3002<\/span><\/p>\n\n\n\n

    \n

    Range(“A1”).Copy
    Range(“C3”).PasteSpecial Paste:=xlPasteValues<\/span><\/p>\n<\/div>\n\n\n\n

    Paste\u5f15\u6570\u306fPasteSpecial\u306e\u7b2c\u4e00\u5f15\u6570\u3067\u7701\u7565\u53ef\u80fd\u306a\u306e\u3067\u3001\u4ee5\u4e0b\u8a18\u8ff0\u3067\u3082\u540c\u3058\u7d50\u679c\u3067\u3059\u3002<\/span><\/p>\n\n\n\n

    \n

    Range(“A1”).Copy
    Range(“C3”).PasteSpecial xlPasteValues<\/p>\n<\/div>\n\n\n\n

    \n

    \u30d1\u30bd\u30b3\u30f3\u30b9\u30af\u30fc\u30ebISA<\/p>\n

    Office\u30fbIT\u30fb\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u7b49\u306e
    \u30d1\u30bd\u30b3\u30f3\u30b9\u30ad\u30eb\u30a2\u30c3\u30d7\u3092\u5fb9\u5e95\u30b5\u30dd\u30fc\u30c8\uff01
    \u6771\u4eac\u3001\u6a2a\u6d5c\u3001\u57fc\u7389\u3001\u5343\u8449\u306e
    \u6700\u5bc4\u99c55\u5206\u4ee5\u5185!\u30aa\u30f3\u30e9\u30a4\u30f3\u6388\u696d\u3082<\/p>\n

    \u7121\u6599\u4f53\u9a13\u30ec\u30c3\u30b9\u30f3\u306b\u7533\u3057\u8fbc\u3080<\/a><\/p>\n