{"id":7074,"date":"2019-09-26T06:00:54","date_gmt":"2019-09-25T21:00:54","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=7074"},"modified":"2021-03-05T10:38:49","modified_gmt":"2021-03-05T01:38:49","slug":"excel-vba-%e3%81%a7%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%81%ae%e3%82%bd%e3%83%bc%e3%83%88%e3%82%92%e8%a8%98%e9%8c%b2%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=7074","title":{"rendered":"EXCEL VBA \u3067\u30c6\u30fc\u30d6\u30eb\u306e\u30bd\u30fc\u30c8\u3092\u8a18\u9332\u3059\u308b"},"content":{"rendered":"\n

\u3000EXCEL VBA \u306b\u81f3\u308b\u524d\u306e\u6bb5\u968e\u3068\u3057\u3066\u30de\u30af\u30ed\u306e\u8a18\u9332\u304c\u3042\u308b\uff0e\u3044\u308f\u3086\u308b\u300c\u8868\u30e2\u30fc\u30c9\u300d\u3092\u305d\u306e\u307e\u307e\u8a18\u9332\u3057\u305f\u3082\u306e\u3067\u3042\u308b\uff0e\u30bd\u30fc\u30c8\u306f\u3053\u308c\u307e\u3067 .Add \u30e1\u30bd\u30c3\u30c9\u304c\u4e2d\u5fc3\u3067\u3042\u3063\u305f\u304c\uff0c\u6700\u8fd1\u306b\u306a\u3063\u3066 .Add2 \u30e1\u30bd\u30c3\u30c9\u304c\u8ffd\u52a0\u3055\u308c\u305f\uff0e\u305d\u308c\u306b\u4f34\u3044\uff0c\u5f15\u6570 Key \u306e Range \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u8a18\u8ff0\u304c\u82e5\u5e72\u5909\u308f\u3063\u305f\uff0e<\/p>\n

<\/p>\n

\u6a19\u6e96\u64cd\u4f5c<\/h3>\n

\u3000\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u5e02\u533a\u753a\u6751\u306b\u306f\u3059\u3067\u306b\u30c6\u30fc\u30d6\u30eb\uff11\u304c\u633f\u5165\u3055\u308c\u3066\u3044\u308b\u524d\u63d0\u3067\u3042\u308b\uff0e\u30c6\u30fc\u30d6\u30eb\u306e\u30bf\u30a4\u30c8\u30eb\u3092\u30d7\u30eb\u30c0\u30a6\u30f3\u3059\u308b\u3068\u30bd\u30fc\u30c8\u3068\u30d5\u30a3\u30eb\u30bf\u30fc\u304c\u51fa\u73fe\u3059\u308b\uff0e\u300c\u6607\u9806\u300d\u3092\u9078\u629e\u3057\u3066\u30de\u30af\u30ed\u306e\u8a18\u9332\u3092\u7d42\u4e86\u3059\u308b\uff0e<\/p>\n

\"\u30bd\u30fc\u30c8\u306e\u30ad\u30fc\u3067\u300c\u6607\u9806\u300d\u3092\u9078\u629e\u3059\u308b\"<\/a>
\u30bd\u30fc\u30c8\u306e\u30ad\u30fc\u3067\u300c\u6607\u9806\u300d\u3092\u9078\u629e\u3059\u308b<\/figcaption><\/figure>\n

\u307e\u305a\u306f\u30de\u30af\u30ed\u306e\u8a18\u9332\u304b\u3089<\/h3>\n

\u3000\u8a18\u9332\u3055\u308c\u305f\u30b3\u30fc\u30c9\u3092\u63b2\u8f09\u3059\u308b\uff0e<\/p>\n

Option Explicit\n\nSub Macro1()\n    ActiveWorkbook.Worksheets(\"\u5e02\u533a\u753a\u6751\").ListObjects(\"\u30c6\u30fc\u30d6\u30eb1\").Sort.SortFields.Clear\n    ActiveWorkbook.Worksheets(\"\u5e02\u533a\u753a\u6751\").ListObjects(\"\u30c6\u30fc\u30d6\u30eb1\").Sort.SortFields.Add2 _\n        Key:=Range(\"\u30c6\u30fc\u30d6\u30eb1[[#All],[\u90fd\u9053\u5e9c\u770c\u30fb\u5e02\u533a\u753a\u6751\u30b3\u30fc\u30c9]]\"), SortOn:=xlSortOnValues, Order _\n        :=xlAscending, DataOption:=xlSortNormal\n    With ActiveWorkbook.Worksheets(\"\u5e02\u533a\u753a\u6751\").ListObjects(\"\u30c6\u30fc\u30d6\u30eb1\").Sort\n        .Header = xlYes\n        .MatchCase = False\n        .Orientation = xlTopToBottom\n        .SortMethod = xlPinYin\n        .Apply\n    End With\nEnd Sub<\/pre>\n
\u8a18\u9332\u3055\u308c\u305f\u30b3\u30fc\u30c9\u3092\u66f8\u304d\u76f4\u3059<\/h3>\n
\u3000\u3053\u306e\u307e\u307e\u3067\u306f\u30b3\u30fc\u30c9\u304c\u5197\u9577\u3067\u8aad\u307f\u306b\u304f\u3044\uff0e\u305d\u306e\u305f\u3081\u5909\u6570\u3092\u3044\u304f\u3064\u304b\u5ba3\u8a00\u3057\u3066\u30b3\u30fc\u30c9\u3092\u66f8\u304d\u76f4\u3059\uff0e<\/p>\n
Sub SortVBA()\nDim mySht   As Worksheet\nDim mySort  As Sort\n\nSet mySht = Worksheets(\"\u5e02\u533a\u753a\u6751\")\nSet mySort = mySht.ListObjects.Item(\"\u30c6\u30fc\u30d6\u30eb1\").Sort\n\nWith mySort\n    .SortFields.Clear\n    .SortFields.Add2 _\n        Key:=Range(\"\u30c6\u30fc\u30d6\u30eb1[[#All],[\u90fd\u9053\u5e9c\u770c\u30fb\u5e02\u533a\u753a\u6751\u30b3\u30fc\u30c9]]\"), _\n        SortOn:=xlSortOnValues, _\n        Order:=xlAscending, _\n        DataOption:=xlSortNormal\n\n    .Header = xlYes\n    .MatchCase = False\n    .Orientation = xlTopToBottom\n    .SortMethod = xlPinYin\n    .Apply\nEnd With\n\nEnd Sub<\/pre>\n
\u30b3\u30fc\u30c9\u306e\u89e3\u8aac<\/h3>\n
\u30009 \u884c\u76ee\u3067\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b SortField \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u7834\u68c4\u3057\uff0c10 \u884c\u76ee\u3067\u65b0\u3057\u304f SortField \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u8ffd\u52a0\u3057\u3066\u3044\u308b\uff0e\u3053\u308c\u306f SortField \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u30bd\u30fc\u30c8\u306e\u898f\u5247\u3092\u4fdd\u6301\u3057\u3066\u304a\u308a\uff0c\u3053\u308c\u307e\u3067\u306e\u30bd\u30fc\u30c8\u306e\u5c65\u6b74\u3092\u8a18\u61b6\u3057\u3066\u3044\u308b\u304b\u3089\u3067\u3042\u308b\uff0e<\/p>\n
\u300011 \u884c\u76ee\u304b\u3089 14 \u884c\u76ee\u3067\u306f\uff0c\u8ffd\u52a0\u3055\u308c\u305f SortField \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bd\u30fc\u30c8\u306e\u898f\u5247\u3092\u8a18\u8ff0\u3057\u3066\u3044\u308b\uff0e\u6700\u3082\u91cd\u8981\u306a\u306e\u306f Key \u3068 Order \u3067\u3042\u308b\uff0e<\/p>\n
\u300016 \u884c\u76ee\u304b\u3089 19 \u884c\u76ee\u307e\u3067\u306f\u4eca\u306f\u6c17\u306b\u3057\u306a\u304f\u3066\u3044\u3044\uff0e\u6700\u5f8c\u306b 20 \u884c\u76ee\u3067\u30bd\u30fc\u30c8\u3092\u9069\u7528\u3057\u3066\u3044\u308b\uff0e<\/p>\n
\u7279\u6b8a\u9805\u76ee\u6307\u5b9a\u5b50[#ALL] \u3068\u306f\uff1f<\/h3>\n
\u3000Add2 \u30e1\u30bd\u30c3\u30c9\u306f EXCEL 2016 \u304b\u3089\u5b9f\u88c5\u3055\u308c\u305f\u6a5f\u80fd\u3067\u3042\u308a\uff0c\u682a\u4fa1\u3068\u5730\u7406\u60c5\u5831\u3067\u30bd\u30fc\u30c8\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\uff0e\u30b8\u30aa\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0<\/a>\u304c\u95a2\u4fc2\u3059\u308b\u306a\u3089\u7a4d\u6975\u7684\u306b\u63a1\u7528\u3059\u3079\u304d\u30e1\u30bd\u30c3\u30c9\u3067\u3042\u308b\uff0e<\/p>\n
\u3000\u6700\u521d\uff0cKey \u306e\u9805\u76ee\u306b\u4ed8\u52a0\u3055\u308c\u305f [#ALL] \u306e\u610f\u5473\u304c\u5206\u304b\u3089\u306a\u304b\u3063\u305f\uff0eRange \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u95a2\u9023\u3060\u308d\u3046\u3068\u5f53\u305f\u308a\u3092\u3064\u3051\u3066\u691c\u7d22\u3059\u308b\u3068 Office Tanaka \u306e\u8a18\u4e8b \u300c\u30c6\u30fc\u30d6\u30eb\u306e\u90e8\u4f4d\u3092\u7279\u5b9a\u3059\u308b\u300d<\/a>\u304c\u30d2\u30c3\u30c8\u3057\u305f\uff0e\u3053\u308c\u306f\u69cb\u9020\u5316\u53c2\u7167\u3068\u3044\u3046\u3082\u306e\u306e\u4e00\u90e8\u3089\u3057\u3044\uff0e<\/p>\n
\u69cb\u9020\u5316\u53c2\u7167<\/h3>\n
\u3000\u69cb\u9020\u5316\u53c2\u7167\u3068\u306fExcel \u30c6\u30fc\u30d6\u30eb\u3067\u306e\u69cb\u9020\u5316\u53c2\u7167\u306e\u4f7f\u3044\u65b9<\/a>\u306b\u3088\u308b\u3068\u300c\u30c6\u30fc\u30d6\u30eb\u540d\u3068\u5217\u540d\u306e\u7d44\u307f\u5408\u308f\u305b\u300d\u306e\u3053\u3068\u3067\u3042\u308a\uff0c\u300c\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u305f\u308a\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057\u305f\u308a\u3059\u308b\u3068\uff0c\u69cb\u9020\u5316\u53c2\u7167\u306e\u540d\u524d\u304c\u5909\u5316\u300d\u3059\u308b\uff0e\u305d\u308c\u306b\u3088\u308a\u300c\u81a8\u5927\u306a\u60c5\u5831\u91cf\u306e\u30d6\u30c3\u30af\u5185\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7c21\u5358\u306b\u898b\u3064\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u300d\u308b\uff0e<\/p>\n
\u3000\u81ea\u5206\u306a\u308a\u306b\u89e3\u91c8\u3059\u308b\u3068\uff0c\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u30c7\u30fc\u30bf\u3092\uff0c\u30bb\u30eb\u53c2\u7167\u3068\u3044\u3046\u5177\u4f53\u7684\u306a\u624b\u7d9a\u304d\u578b\u306e\u30ec\u30d9\u30eb\u304b\u3089\uff0c\u3088\u308a\u62bd\u8c61\u7684\u306a\u96c6\u5408\u6307\u5411\u306e\u30ec\u30d9\u30eb\u306b\u5f15\u304d\u4e0a\u3052\u305f\uff0c\u3068\u3044\u3046\u3082\u306e\u3067\u3042\u308d\u3046\uff0eSQL \u3068\u4f3c\u3066\u3044\u308b\u6c17\u3082\u3059\u308b\uff0e<\/p>\n
SELECT  *  FROM [\u30c6\u30fc\u30d6\u30eb1]  ORDER BY  [\u5e02\u533a\u753a\u6751\u30b3\u30fc\u30c9]<\/pre>\n
\u30c6\u30fc\u30d6\u30eb\u6307\u5b9a\u5b50 = \u7279\u6b8a\u9805\u76ee\u6307\u5b9a\u5b50 + \u5217\u6307\u5b9a\u5b50<\/h3>\n
\u3000\u69cb\u9020\u5316\u53c2\u7167\u3067\u306f\u5217\u898b\u51fa\u3057\u3092\u4f7f\u3063\u305f\u300c\u5217\u6307\u5b9a\u5b50\u300d\u3068\uff0c\u30c6\u30fc\u30d6\u30eb\u5185\u3067\u4efb\u610f\u306e\u7bc4\u56f2\u3092\u8868\u3059\u300c\u7279\u6b8a\u9805\u76ee\u6307\u5b9a\u5b50\u300d\u3092\u4f7f\u7528\u3067\u304d\u308b\uff0e\u3053\u308c\u3089\u4e8c\u3064\u306e\u6307\u5b9a\u5b50\u3092\u5408\u308f\u305b\u3066\u300c\u30c6\u30fc\u30d6\u30eb\u6307\u5b9a\u5b50\u300d\u3068\u547c\u3076\uff0e\u3053\u306e\u3042\u305f\u308a\u306f EXCEL 2007 \u3067\u5b9f\u88c5\u3055\u308c\u305f\u6a5f\u80fd\u3067\u3042\u308b\uff0e<\/p>\n
\u30c6\u30fc\u30d6\u30eb\u540d[[\u7279\u6b8a\u9805\u76ee\u6307\u5b9a\u5b50],[\u5217\u6307\u5b9a\u5b50]]<\/pre>\n
EXCEL\u306e\u30c6\u30fc\u30d6\u30eb\u306f\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u306e\u6a4b\u6e21\u3057<\/h3>\n
\u3000\u601d\u3044\u8fd4\u3059\u3068\uff0c\u30c6\u30fc\u30d6\u30eb\u5185\u3067\u6570\u5f0f\u3092\u8a18\u8ff0\u3057\u3066\u3044\u308b\u969b\u306b\u3082\u69cb\u9020\u5316\u53c2\u7167\u304c\u4f7f\u308f\u308c\u3066\u3044\u305f\u305f\u3081\uff0c\u5165\u529b\u304c\u697d\u3060\u3063\u305f\u6c17\u304c\u3059\u308b\uff08\u6570\u5f0f\u30aa\u30fc\u30c8\u30b3\u30f3\u30d7\u30ea\u30fc\u30c8\uff09\uff0e\u3057\u3066\u307f\u308b\u3068\uff0cListObject \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f EXCEL \u5185\u306b\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u6301\u3061\u8fbc\u3082\u3046\u3068\u3057\u3066\u3044\u308b\u306e\u304b\u3082\u77e5\u308c\u306a\u3044\uff0e<\/p>\n
\u3000\u7530\u4e2d\u4ea8\u306f\u300e\u3053\u3053\u306f\u300c\u305d\u3046\u3044\u3046\u3082\u306e\u306a\u3093\u3060\u300d\u3068\u98f2\u307f\u8fbc\u3093\u3067\u300c\u305d\u3046\u304b\u9055\u3046\u306e\u304b\u300d\u3068\u7d0d\u5f97\u3059\u308b\u3068\u3053\u308d\u300f\u3068\u66f8\u3044\u3066\u3044\u308b\u304c\uff0c\u3053\u306e\u9055\u548c\u611f\u306f\u624b\u7d9a\u304d\u578b\u8a00\u8a9e\u3068\u96c6\u5408\u6307\u5411\u8a00\u8a9e\u306e\u601d\u60f3\u306e\u9055\u3044\u306b\u7531\u6765\u3059\u308b\uff0e<\/p>\n
\u7279\u6b8a\u9805\u76ee\u6307\u5b9a\u5b50\u3068ListObject\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u985e\u4f3c\u70b9<\/h3>\n
\u3000\u7279\u6b8a\u9805\u76ee\u6307\u5b9a\u5b50\u3068 ListObject \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u306f\u985e\u4f3c\u70b9\u304c\u591a\u3044\uff0e<\/p>\n\n\n\n\n\n\n\n\n
\u7279\u6b8a\u9805\u76ee\u6307\u5b9a\u5b50<\/th>\n\u53c2\u7167\u5148<\/th>\nListObject<\/th>\n<\/tr>\n
#All<\/td>\n\u30c6\u30fc\u30d6\u30eb\u5168\u4f53<\/td>\n.Range<\/td>\n<\/tr>\n
#Data<\/td>\n\u30c7\u30fc\u30bf\u884c\u306e\u307f<\/td>\n.DataBodyRange<\/td>\n<\/tr>\n
#Headers<\/td>\n\u898b\u51fa\u3057\u884c\u306e\u307f<\/td>\n.HeaderRowRange<\/td>\n<\/tr>\n
#Totals<\/td>\n\u5408\u8a08\u884c\u306e\u307f<\/td>\n.TotalRowRange<\/td>\n<\/tr>\n
@[ColumnName]<\/td>\n\u6570\u5f0f\u3068\u540c\u3058\u884c\u306e\u30bb\u30eb<\/td>\n.ListColumns<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u3000\u4e21\u8005\u306f\u307b\u307c\u540c\u3058\u3082\u306e<\/a>\u3067\u3042\u308b\u3068\u7530\u4e2d\u4ea8\u306f\u8ff0\u3079\u3066\u3044\u308b\u304c\uff0c\u3069\u3061\u3089\u306e\u62bd\u8c61\u5ea6\u304c\u9ad8\u3044\u306e\u304b\u306f\u4eca\u306f\u3088\u304f\u5206\u304b\u3089\u306a\u3044\uff0e<\/p>\n
\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u3067 Sort \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4fef\u77b0\u3059\u308b<\/h3>\n
\u3000\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u304b\u3089 Sort \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/a>\u3092\u691c\u7d22\u3059\u308b\u3068\uff0c2 \u4ef6\u306e\u30e1\u30bd\u30c3\u30c9\u3068 9 \u4ef6\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u304c\u51fa\u3066\u304f\u308b\uff0e<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
CLASS<\/th>\nMEMBER<\/th>\nReturm<\/th>\n<\/tr>\n
Sort<\/td>\nApplication<\/td>\nApplication<\/td>\n<\/tr>\n
\u00a0<\/td>\nApply<\/a><\/td>\nSub<\/td>\n<\/tr>\n
\u00a0<\/td>\nCreator<\/td>\nXlCreator<\/a><\/td>\n<\/tr>\n
\u00a0<\/td>\nHeader<\/a><\/td>\nXlYesNoGuess<\/a><\/td>\n<\/tr>\n
\u00a0<\/td>\nMatchCase<\/a><\/td>\nBoolean<\/td>\n<\/tr>\n
\u00a0<\/td>\nOrientation<\/a><\/td>\nXlSortOrientation<\/a><\/td>\n<\/tr>\n
\u00a0<\/td>\nParent<\/td>\nObject<\/td>\n<\/tr>\n
\u00a0<\/td>\nRng<\/a><\/td>\nRange<\/td>\n<\/tr>\n
\u00a0<\/td>\nSetRange<\/a><\/td>\nSub<\/td>\n<\/tr>\n
\u00a0<\/td>\nSortFields<\/strong><\/a><\/td>\nSortFields<\/td>\n<\/tr>\n
\u00a0<\/td>\nSortMethod<\/a><\/td>\nXlSortMethod<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u3000\u3053\u306e\u4e2d\u3067\u7279\u306b\u91cd\u8981\u306a\u30d7\u30ed\u30d1\u30c6\u30a3\u306f SortFields \u30d7\u30ed\u30d1\u30c6\u30a3<\/a>\u3067\u3042\u308b\uff0e\u8907\u6570\u5f62\u306b\u306a\u3063\u3066\u304a\u308a\uff0cSortField \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u3042\u308d\u3046\u3068\u63a8\u6e2c\u3055\u308c\u308b\uff0e\u305d\u3053\u3067\u3055\u3089\u306b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u3067\u691c\u7d22\u3059\u308b\uff0e<\/p>\n
SortFields \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/h3>\n\n\n\n\n\n\n\n\n\n\n\n
CLASS<\/th>\nMEMBER<\/th>\nReturn<\/th>\n<\/tr>\n
SortFields<\/td>\nAdd<\/a><\/td>\nSortField<\/td>\n<\/tr>\n
\u00a0<\/td>\nAdd2<\/a><\/td>\nSortField<\/td>\n<\/tr>\n
\u00a0<\/td>\nApplication<\/td>\nApplication<\/td>\n<\/tr>\n
\u00a0<\/td>\nClear<\/a><\/td>\nSub<\/td>\n<\/tr>\n
\u00a0<\/td>\nCount<\/a><\/td>\nLong<\/td>\n<\/tr>\n
\u00a0<\/td>\nCreator<\/td>\nXlCreator<\/td>\n<\/tr>\n
\u00a0<\/td>\nItem<\/a><\/td>\nSortField<\/td>\n<\/tr>\n
\u00a0<\/td>\nParent<\/td>\nObject<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
SortField \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/h3>\n
\u3000SortField \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/a>\u306b\u306f 3 \u4ef6\u306e\u30e1\u30bd\u30c3\u30c9\u3068 11 \u4ef6\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u304c\u3042\u308b\uff0e<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
CLASS<\/th>\nMEMBER<\/th>\nReturn<\/th>\n<\/tr>\n
SortField<\/td>\nApplication<\/td>\nApplication<\/td>\n<\/tr>\n
\u00a0<\/td>\nCreator<\/td>\nXlCreator<\/a><\/td>\n<\/tr>\n
\u00a0<\/td>\nCustomOrder<\/a><\/td>\nVariant<\/td>\n<\/tr>\n
\u00a0<\/td>\nDataOption<\/a><\/td>\nXlDataOption<\/td>\n<\/tr>\n
\u00a0<\/td>\nDelete<\/a><\/td>\nSub<\/td>\n<\/tr>\n
\u00a0<\/td>\nKey<\/strong><\/td>\nRange<\/td>\n<\/tr>\n
\u00a0<\/td>\nModifyKey<\/a><\/td>\nSub<\/td>\n<\/tr>\n
\u00a0<\/td>\nOrder<\/strong><\/td>\nXlSortOrder<\/a><\/td>\n<\/tr>\n
\u00a0<\/td>\nParent<\/td>\nObject<\/td>\n<\/tr>\n
\u00a0<\/td>\nPriority<\/a><\/td>\nLong<\/td>\n<\/tr>\n
\u00a0<\/td>\nSetIcon<\/a><\/td>\nSub<\/td>\n<\/tr>\n
\u00a0<\/td>\nSortOn<\/a><\/td>\nXlSortOn<\/a><\/td>\n<\/tr>\n
\u00a0<\/td>\nSortOnValue<\/a><\/td>\nObject<\/td>\n<\/tr>\n
\u00a0<\/td>\nSubField<\/td>\nVariant<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u3000\u3053\u306e\u4e2d\u3067\u91cd\u8981\u306a\u30d7\u30ed\u30d1\u30c6\u30a3\u306f Key<\/a> \u304a\u3088\u3073 Order<\/a> \u3067\u3042\u308b\uff0e\u305d\u3053\u3067\u305d\u308c\u305e\u308c\u3092\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u3067\u3055\u3089\u306b\u6398\u308a\u4e0b\u3052\u308b\uff0e<\/p>\n
Key \u30d7\u30ed\u30d1\u30c6\u30a3\u306b\u306f Range \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6307\u5b9a\u3059\u308b<\/h4>\n
\u3000\u5148\u7a0b\u306e\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u3067\u306fKey:=Range(“\u30c6\u30fc\u30d6\u30eb1[[#All],[\u90fd\u9053\u5e9c\u770c\u30fb\u5e02\u533a\u753a\u6751\u30b3\u30fc\u30c9]]”)<\/span> \u3068\u3044\u3046\u3075\u3046\u306b Range \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6307\u5b9a\u3057\u305f\uff0eRange \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u306f\u69cb\u9020\u5316\u53c2\u7167\u304c\u4f7f\u3048\u308b\uff0e<\/p>\n
\u3000[] \u306e\u9593\u306b\u3042\u308b\u30b3\u30f3\u30de (,) \u306f\u53c2\u7167\u6f14\u7b97\u5b50<\/a>\u306e\u4e00\u3064\u3067\u3042\u308a\uff0c\u8ad6\u7406\u548c\u3092\u793a\u3059\uff0e\u30b3\u30ed\u30f3 (:) \u306f\u7bc4\u56f2\u6f14\u7b97\u5b50\u3067\u3042\u308a\uff0c\u96a3\u63a5\u3059\u308b\u8907\u6570\u306e\u5217\u306b\u542b\u307e\u308c\u308b\u5168\u3066\u306e\u30bb\u30eb\u3092\u793a\u3059\uff0e\u7a7a\u767d ( ) \u306f\u8ad6\u7406\u7a4d\u3092\u793a\u3059\uff0e<\/p>\n
\"SortField\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306eKey\u30d7\u30ed\u30d1\u30c6\u30a3\u306b\u306fRange\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6307\u5b9a\u3059\u308b\"<\/a>
SortField\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306eKey\u30d7\u30ed\u30d1\u30c6\u30a3\u306b\u306fRange\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6307\u5b9a\u3059\u308b<\/figcaption><\/figure>\n
Order \u30d7\u30ed\u30d1\u30c6\u30a3\u306b\u306f\u5b9a\u6570\u3092\u6307\u5b9a\u3059\u308b<\/h4>\n
\u3000SortField \u306e\u30e1\u30f3\u30d0\u30fc\u3067\u3042\u308b Order \u30d7\u30ed\u30d1\u30c6\u30a3\u306f XlSortOrder<\/a> \u3068\u3044\u3046\u30af\u30e9\u30b9\u306b\u8a72\u5f53\u3059\u308b\uff0e\u3053\u306e\u8a9e\u53e5\u3092\u3055\u3089\u306b\u691c\u7d22\u3059\u308b\uff0e<\/p>\n
\"SortField\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306eOrder\u30d7\u30ed\u30d1\u30c6\u30a3\u306b\u306f\u5b9a\u6570\u3092\u6307\u5b9a\u3059\u308b\"<\/a>
SortField\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306eOrder\u30d7\u30ed\u30d1\u30c6\u30a3\u306b\u306f\u5b9a\u6570\u3092\u6307\u5b9a\u3059\u308b<\/figcaption><\/figure>\n
\u5b9a\u6570 XlSortOrder \u306b\u306f\u6607\u9806 (XlAscending) \u3068\u964d\u9806 (XlDescending) \u304c\u3042\u308b<\/h4>\n
\u3000\u5b9a\u6570 XlSortOrder \u306b\u306f\u6607\u9806 (XlAscending = 1) \u3068\u964d\u9806 (XlDescending = 2) \u304c\u3042\u308b\u3053\u3068\u304c\u5206\u304b\u308b\uff0e\u516c\u5f0f\u306b\u306f\u3055\u3089\u306b\u624b\u52d5 (XlManual = -4135) \u3082\u3042\u308b\uff0e<\/p>\n
\"XlSortOrder<\/a>
XlSortOrder \u306b\u306f\u6607\u9806 (XlAscending) \u3068\u964d\u9806 (XlDescending) \u304c\u3042\u308b<\/figcaption><\/figure>\n
\u307e\u3068\u3081<\/h3>\n
\u3000\u30de\u30af\u30ed\u8a18\u9332\u304b\u3089\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u306e\u691c\u7d22\u306b\u81f3\u308b\u307e\u3067\uff0cEXCEL \u306e\u30c6\u30fc\u30d6\u30eb\u306e\u30bd\u30fc\u30c8\u6a5f\u80fd\u3092 VBA \u5074\u304b\u3089\u4fef\u77b0\u3057\u305f\uff0e\u5358\u306a\u308b\u30bb\u30eb\u7bc4\u56f2\u306e\u30bd\u30fc\u30c8\u3068\u306f\u7570\u306a\u308a\uff0c\u30c6\u30fc\u30d6\u30eb\u306f\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u306e\u89aa\u548c\u6027\u304c\u975e\u5e38\u306b\u9ad8\u3044\u3053\u3068\u304c\u5206\u304b\u3063\u305f\uff0e<\/p>\n
\u3000\u30bd\u30fc\u30c8\u6a5f\u80fd\u3082\u9032\u5316\u3057\u7d9a\u3051\u3066\u304a\u308a\uff0c\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u578b\u306b\u5bfe\u5fdc\u3057\u305f\u30e1\u30bd\u30c3\u30c9\u304c\u8ffd\u52a0\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u5206\u304b\u3063\u305f\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3000EXCEL VBA \u306b\u81f3\u308b\u524d\u306e\u6bb5\u968e\u3068\u3057\u3066\u30de\u30af\u30ed\u306e\u8a18\u9332\u304c\u3042\u308b\uff0e\u3044\u308f\u3086\u308b\u300c\u8868\u30e2\u30fc\u30c9\u300d\u3092\u305d\u306e\u307e\u307e\u8a18\u9332\u3057\u305f\u3082\u306e\u3067\u3042\u308b\uff0e\u30bd\u30fc\u30c8\u306f\u3053\u308c\u307e\u3067 .Add \u30e1\u30bd\u30c3\u30c9\u304c\u4e2d\u5fc3\u3067\u3042\u3063\u305f\u304c\uff0c\u6700\u8fd1\u306b\u306a\u3063\u3066 .Add2 \u30e1\u30bd\u30c3\u30c9\u304c\u8ffd\u52a0\u3055\u308c\u305f\uff0e\u305d\u308c\u306b … <\/p>\n
“EXCEL VBA \u3067\u30c6\u30fc\u30d6\u30eb\u306e\u30bd\u30fc\u30c8\u3092\u8a18\u9332\u3059\u308b” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[4685,4686,4687,4631,4709,4688,4637,4527,4693,4656,5608,4640,4694,4697,4689,4646,4698,4636,4659,265,4683,4665,4651,4673,4648,4690,4632,4692,4586,4675,4650,4699,4773,4634,4644,4674,4652,4695,4700,4530,4672,4657,4701,4696,4638,4660,4639,4661,4654,4642,4702,259,4635,4703,4691,5809,459,4658,4599,4645,8421,9632,4712,9634,4655,9631,4647,9633,4643,4711,9630,4653,4649,9629,4641,460,4554,4581,4706,2937,4012,4669,673,444,462,2915,4681,4633,646,1669,438,4629,4552,464,663,4668,4682,1806,4704,4666,3248,4663,3549,4670,4677,4671,4684,1034,1107,4667,4664,4676,4662,1019,4707,4630,4582,1288,2591,4705,4710,2834,2956,4708,3992,4680],"class_list":{"0":"post-7074","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-technology","7":"tag-data","8":"tag-headers","9":"tag-totals","10":"tag-add2","11":"tag-4709","12":"tag-columnname","13":"tag-activeworkbook","14":"tag-add","15":"tag-application","16":"tag-apply","17":"tag-boolean","18":"tag-clear","19":"tag-creator","20":"tag-customorder","21":"tag-databodyrange","22":"tag-dataoption","23":"tag-delete","24":"tag-end-sub","25":"tag-end-with","26":"tag-excel","27":"tag-excel2007","28":"tag-excel2016","29":"tag-false","30":"tag-from","31":"tag-header","32":"tag-headerrowrange","33":"tag-key","34":"tag-listcolumns","35":"tag-listobjects","36":"tag-listobject","37":"tag-matchcase","38":"tag-modifykey","39":"tag-object","40":"tag-option-explicit","41":"tag-order","42":"tag-order-by","43":"tag-orientation","44":"tag-parent","45":"tag-priority","46":"tag-range","47":"tag-select","48":"tag-set","49":"tag-seticon","50":"tag-setrange","51":"tag-sort","52":"tag-sortfield","53":"tag-sortfields","55":"tag-sortmethod","56":"tag-sorton","57":"tag-sortonvalue","58":"tag-sql","59":"tag-sub","60":"tag-subfield","61":"tag-totalrowrange","62":"tag-variant","63":"tag-vba","64":"tag-with","65":"tag-worksheets","66":"tag-xlascending","67":"tag-xlcreator","68":"tag-xldataoption","69":"tag-xldescending","70":"tag-xlmanual","71":"tag-xlpinyin","72":"tag-xlsortmethod","73":"tag-xlsortnormal","74":"tag-xlsorton","75":"tag-xlsortonvalues","76":"tag-xlsortorder","77":"tag-xlsortorientation","78":"tag-xltoptobottom","79":"tag-xlyes","80":"tag-xlyesnoguess","81":"tag-all","82":"tag-460","83":"tag-4554","84":"tag-4581","85":"tag-4706","86":"tag-2937","87":"tag-4012","88":"tag-4669","89":"tag-673","90":"tag-444","91":"tag-462","92":"tag-2915","93":"tag-4681","94":"tag-4633","95":"tag-646","96":"tag-1669","97":"tag-438","98":"tag-4629","99":"tag-4552","100":"tag-464","101":"tag-663","102":"tag-4668","103":"tag-4682","104":"tag-1806","105":"tag-4704","106":"tag-4666","107":"tag-3248","108":"tag-4663","109":"tag-3549","110":"tag-4670","111":"tag-4677","112":"tag-4671","113":"tag-4684","114":"tag-1034","115":"tag-1107","116":"tag-4667","117":"tag-4664","118":"tag-4676","119":"tag-4662","120":"tag-1019","121":"tag-4707","122":"tag-4630","123":"tag-4582","124":"tag-1288","125":"tag-2591","126":"tag-4705","127":"tag-4710","128":"tag-2834","129":"tag-2956","130":"tag-4708","131":"tag-3992","132":"tag-4680"},"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/7074","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7074"}],"version-history":[{"count":80,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/7074\/revisions"}],"predecessor-version":[{"id":14031,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/7074\/revisions\/14031"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}