{"id":4007,"date":"2023-06-02T12:00:28","date_gmt":"2023-06-02T03:00:28","guid":{"rendered":"https:\/\/www.bold.ne.jp\/engineer-club\/?p=4007"},"modified":"2025-11-19T11:10:48","modified_gmt":"2025-11-19T02:10:48","slug":"vba-find","status":"publish","type":"post","link":"https:\/\/www.bold.ne.jp\/engineer-club\/vba-find","title":{"rendered":"VBA\u306eFind\u30e1\u30bd\u30c3\u30c9\u3068\u306f\uff1f\u95a2\u6570\u306e\u89e3\u8aac\u3068\u4f7f\u7528\u4f8b"},"content":{"rendered":"<p>Ecxel\u306e\u6a19\u6e96\u6a5f\u80fd\u3067\u3042\u308b\u691c\u7d22\u6a5f\u80fd\u3092\u4f7f\u3063\u305f\u3053\u3068\u306f\u3042\u308a\u307e\u3059\u304b\uff1f<\/p>\n<p>ExcelVBA\u3067\u3082\u4f3c\u305f\u51e6\u7406\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001<span>Find<\/span>\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u672c\u7684\u306a\u89e3\u8aac\u3092\u884c\u3063\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<div id=\"toc_container\" class=\"no_bullets\"><p class=\"toc_title\">\u76ee\u6b21<\/p><ul class=\"toc_list\"><li><a href=\"#VBAFind\">\uff11\uff0eVBA\u306eFind\u30e1\u30bd\u30c3\u30c9\u306b\u3064\u3044\u3066<\/a><ul><li><a href=\"#-Find\">\uff11-\uff11\uff0eFind\u30e1\u30bd\u30c3\u30c9\u3068\u306f<\/a><\/li><li><a href=\"#-Find-2\">\uff11-\uff12\uff0eFind\u30e1\u30bd\u30c3\u30c9\u306e\u69cb\u6587<\/a><\/li><\/ul><\/li><li><a href=\"#VBA_Find\">\uff12\uff0eVBA Find\u30e1\u30bd\u30c3\u30c9\u306e\u4f7f\u7528\u4f8b<\/a><ul><li><a href=\"#i\">\uff12-\uff11\uff0e\u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b<\/a><\/li><li><a href=\"#i-2\">\uff12-\uff12\uff0e\u4f7f\u7528\u3067\u6ce8\u610f\u3059\u308b\u70b9<\/a><\/li><\/ul><\/li><li><a href=\"#i-3\">\uff13\uff0e\u6700\u5f8c\u306b<\/a><\/li><\/ul><\/div>\n<h2><span id=\"VBAFind\">\uff11\uff0eVBA\u306eFind\u30e1\u30bd\u30c3\u30c9\u306b\u3064\u3044\u3066<\/span><\/h2>\n<h3><span id=\"-Find\">\uff11-\uff11\uff0eFind\u30e1\u30bd\u30c3\u30c9\u3068\u306f<\/span><\/h3>\n<p>Find\u30e1\u30bd\u30c3\u30c9\u3068\u306f\u3001<strong>\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u7bc4\u56f2\u5185\u3067\u7279\u5b9a\u306e\u60c5\u5831\u3092\u691c\u7d22\u3059\u308b\u95a2\u6570<\/strong>\u3067\u3059\u3002<span>Excel<\/span>\u3067\u306e\u300c<span>Ctrl <\/span>\uff0b<span> F<\/span>\u300d\u30ad\u30fc\u3067\u8868\u793a\u3055\u308c\u308b\u4e0b\u8a18\u306e\u691c\u7d22\u6a5f\u80fd\u3068\u307b\u307c\u540c\u3058\u6a5f\u80fd\u304c\u4f7f\u3048\u307e\u3059\u3002<\/p>\n<h3><span id=\"-Find-2\">\uff11-\uff12\uff0eFind\u30e1\u30bd\u30c3\u30c9\u306e\u69cb\u6587<\/span><\/h3>\n<pre class=\"prettyprint lang:default decode:true\">Find (What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte, SearchFormat)<\/pre>\n<p>\u8a2d\u5b9a\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u5024\u306f\u3001\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n<p><strong><\/strong><span class=\"f-marker-w\"><strong>\u8868\uff11\uff0e\u30aa\u30d7\u30b7\u30e7\u30f3\u4e00\u89a7<\/strong><\/span><br \/>\n<a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/\u30aa\u30d7\u30b7\u30e7\u30f3\u4e00\u89a7.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/\u30aa\u30d7\u30b7\u30e7\u30f3\u4e00\u89a7.png\" alt=\"\u30aa\u30d7\u30b7\u30e7\u30f3\u4e00\u89a7\" width=\"1109\" height=\"1316\" class=\"alignnone size-full wp-image-4009\" srcset=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/\u30aa\u30d7\u30b7\u30e7\u30f3\u4e00\u89a7.png 1109w, https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/\u30aa\u30d7\u30b7\u30e7\u30f3\u4e00\u89a7-863x1024.png 863w, https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/\u30aa\u30d7\u30b7\u30e7\u30f3\u4e00\u89a7-768x911.png 768w\" sizes=\"(max-width: 1109px) 100vw, 1109px\" \/><\/a><\/p>\n<p>Excel\u306e\u691c\u7d22\u6a5f\u80fd\u3067\u4f7f\u7528\u3059\u308b\u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u3001<span>VBA<\/span>\u306e\u691c\u7d22\u30aa\u30d7\u30b7\u30e7\u30f3\u3068\u540c\u3058\u6a5f\u80fd\u304c\u591a\u304f\u3042\u308a\u3001\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u5439\u304d\u51fa\u3057\u306b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p><strong><span class=\"f-marker-p\">\u56f3\uff11\uff0eExcel\u3067\u306e\u691c\u7d22\u3068VBA\u306e\u691c\u7d22\u30aa\u30d7\u30b7\u30e7\u30f3\u6bd4\u8f03<br \/>\n<\/span><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/Excel\u3067\u306e\u691c\u7d22\u3068VBA\u306e\u691c\u7d22\u30aa\u30d7\u30b7\u30e7\u30f3\u6bd4\u8f03.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/Excel\u3067\u306e\u691c\u7d22\u3068VBA\u306e\u691c\u7d22\u30aa\u30d7\u30b7\u30e7\u30f3\u6bd4\u8f03.png\" alt=\"Excel\u3067\u306e\u691c\u7d22\u3068VBA\u306e\u691c\u7d22\u30aa\u30d7\u30b7\u30e7\u30f3\u6bd4\u8f03\" width=\"904\" height=\"431\" class=\"alignnone size-full wp-image-4010\" srcset=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/Excel\u3067\u306e\u691c\u7d22\u3068VBA\u306e\u691c\u7d22\u30aa\u30d7\u30b7\u30e7\u30f3\u6bd4\u8f03.png 904w, https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/Excel\u3067\u306e\u691c\u7d22\u3068VBA\u306e\u691c\u7d22\u30aa\u30d7\u30b7\u30e7\u30f3\u6bd4\u8f03-768x366.png 768w\" sizes=\"(max-width: 904px) 100vw, 904px\" \/><\/a><br \/>\n<\/strong><\/p>\n<h2><span id=\"VBA_Find\">\uff12\uff0eVBA Find\u30e1\u30bd\u30c3\u30c9\u306e\u4f7f\u7528\u4f8b<\/span><\/h2>\n<h3><span id=\"i\">\uff12-\uff11\uff0e\u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b<\/span><\/h3>\n<h4>\uff12-\uff11-\uff11\uff0e\u521d\u671f\u5024\u8a2d\u5b9a<\/h4>\n<p>\u4e0b\u8a18\u8868\u3092\u4f7f\u3063\u3066\u3001\u691c\u7d22\u306e<span>VBA<\/span>\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n<p><strong><span class=\"f-marker-p\">\u8868\uff12\uff0e\u691c\u7d22<br \/>\n<\/span><\/strong><\/p>\n<table width=\"321\" style=\"width: 49.6085%;\">\n<tbody>\n<tr>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u611b\u77e5\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5e83\u5cf6\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u65b0\u6f5f\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 82.5153%;\">\n<p>\u6771\u4eac\u90fd<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u611b\u5a9b\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u9999\u5ddd\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u795e\u5948\u5ddd\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 82.5153%;\">\n<p>\u5fb3\u5cf6\u770c<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u8328\u57ce\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u9ad8\u77e5\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u9752\u68ee\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 82.5153%;\">\n<p>\u6803\u6728\u770c<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5ca1\u5c71\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u4f50\u8cc0\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u9759\u5ca1\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 82.5153%;\">\n<p>\u5948\u826f\u770c<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u6c96\u7e04\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u57fc\u7389\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u77f3\u5ddd\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 82.5153%;\">\n<p>\u5bcc\u5c71\u770c<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5ca9\u624b\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u4e09\u91cd\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5343\u8449\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 82.5153%;\">\n<p>\u798f\u4e95\u770c<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5c90\u961c\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5c71\u5f62\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5927\u962a\u5e9c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 82.5153%;\">\n<p>\u798f\u5ca1\u770c<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5bae\u5d0e\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5c71\u53e3\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5927\u5206\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 82.5153%;\">\n<p>\u798f\u5cf6\u770c<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5bae\u57ce\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5c71\u68a8\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u9577\u5d0e\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 82.5153%;\">\n<p>\u5175\u5eab\u770c<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u4eac\u90fd\u5e9c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u6ecb\u8cc0\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u9577\u91ce\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 82.5153%;\">\n<p>\u5317\u6d77\u9053<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u718a\u672c\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u9e7f\u5150\u5cf6\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u9ce5\u53d6\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 82.5153%;\">\n<p>\u548c\u6b4c\u5c71\u770c<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u7fa4\u99ac\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u79cb\u7530\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 24.8466%;\">\n<p>\u5cf6\u6839\u770c<\/p>\n<\/td>\n<td width=\"80\" style=\"width: 82.5153%;\">\n<p>&nbsp;<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>\u00a0<\/strong><\/p>\n<pre class=\"prettyprint lang:default decode:true\">Sub sample01()\r\n\r\n    Dim sampleRange As Range    '\u691c\u7d22\u3059\u308b\u30c7\u30fc\u30bf\r\n    Dim result As Range          '\u691c\u7d22\u7d50\u679c\u3092\u683c\u7d0d\u3059\u308b\r\n    \r\n    Set sampleRange = Range(\"A1:E10\")\r\n    keyWord = \"\u4eac\u90fd\"\r\n    '\u691c\u7d22\u30ef\u30fc\u30c9\u3092\u300c\u4eac\u90fd\u300d\u3001\u5b8c\u5168\u4e00\u81f4\u3067\u691c\u7d22\u5b9f\u65bd\r\n    Set result = sampleRange.Find(keyWord, LookAt:=xlPart)\r\n    \r\n    If result Is Nothing Then\r\n        MsgBox \"'\" &amp; keyWord &amp; \"'\u306f\u3042\u308a\u307e\u305b\u3093\u3067\u3057\u305f\"\r\n        Exit Sub\r\n    Else\r\n        Dim row As Integer\r\n        row = result.row\r\n        MsgBox \"\u300c\" &amp; result.Value &amp; \"\u300d\u304c\u30d2\u30c3\u30c8\u3057\u307e\u3057\u305f\u3002\"\r\n    End If\r\n\r\nEnd Sub\r\n<\/pre>\n<p><strong><span class=\"f-marker-g\">\u5b9f\u884c\u7d50\u679c\uff1a<\/span><\/strong><\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/\u5b9f\u884c\u7d50\u679c1.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/\u5b9f\u884c\u7d50\u679c1.png\" alt=\"\u5b9f\u884c\u7d50\u679c1\" width=\"206\" height=\"186\" class=\"alignnone size-full wp-image-4011\" \/><\/a><\/p>\n<h3><span id=\"i-2\">\uff12-\uff12\uff0e\u4f7f\u7528\u3067\u6ce8\u610f\u3059\u308b\u70b9<\/span><\/h3>\n<p>\u7b2c\u4e8c\u5f15\u6570\u4ee5\u964d\u3092\u8a2d\u5b9a\u3057\u3066\u691c\u7d22\u3092\u884c\u3046\u3068\u3001\u5f15\u6570\u306e\u8a2d\u5b9a\u304c\u4fdd\u5b58\u3055\u308c\u307e\u3059\u3002\u5225\u306e\u8a2d\u5b9a\u3067\u691c\u7d22\u3092\u884c\u3046\u969b\u306b\u3001\u524d\u56de\u8a2d\u5b9a\u3057\u305f\u5f15\u6570\u3092\u7701\u7565\u3057\u305f\u5834\u5408\u306f\u3001\u524d\u56de\u8a2d\u5b9a\u3057\u305f\u5f15\u6570\u304c\u53cd\u6620\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u4f8b\u3068\u3057\u3066\u3001\u8868\uff11\u3092\u5bfe\u8c61\u3068\u3057\u3066\u4e0b\u8a18\u306e\u691c\u7d22\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6307\u5b9a\u3057\u3066\u300c\u4eac\u90fd\u5e9c\u300d\u3092\u691c\u7d22\u3059\u308b\u51e6\u7406\u3092\u9023\u7d9a\u3067\u884c\u3044\u307e\u3059\u3002<\/p>\n<p>1\u56de\u76ee\u306e\u691c\u7d22\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u8a2d\u5b9a<\/p>\n<p>\u8868\uff11\u306b\u5bfe\u3057\u3066\u3001\u4e0b\u8a18\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6307\u5b9a\u3057\u3066\u691c\u7d22<\/p>\n<ul>\n<li>\u691c\u7d22\u6587\u5b57\u3092\u300c\u4eac\u90fd\u300d<\/li>\n<li>\u300c\u90e8\u5206\u4e00\u81f4\u300d<\/li>\n<li>\u691c\u7d22\u9806\u3092\u300c\u5217\u3092\u4e0b\u7aef\u307e\u3067\u691c\u7d22\u3057\u3066\u304b\u3089\u6b21\u306e\u5217\u3092\u691c\u7d22\u300d<\/li>\n<\/ul>\n<p><strong><span class=\"f-marker-g\">\u5b9f\u884c\u7d50\u679c\uff1a<\/span><\/strong><\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/\u5b9f\u884c\u7d50\u679c2.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/\u5b9f\u884c\u7d50\u679c2.png\" alt=\"\u5b9f\u884c\u7d50\u679c2\" width=\"206\" height=\"186\" class=\"alignnone size-full wp-image-4012\" \/><\/a><\/p>\n<p>2\u56de\u76ee\u306e\u691c\u7d22\u30aa\u30d7\u30b7\u30e7\u30f3\u8a2d\u5b9a<\/p>\n<p>\u8868\uff11\u306b\u5bfe\u3057\u3066\u3001\u4e0b\u8a18\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6307\u5b9a\u3057\u3066\u691c\u7d22<\/p>\n<ul>\n<li>\u691c\u7d22\u6587\u5b57\u3092\u300c\u4eac\u90fd\u300d<\/li>\n<li>\u691c\u7d22\u9806\u3092\u300c\u884c\u3092\u53f3\u7aef\u307e\u3067\u691c\u7d22\u3057\u3066\u304b\u3089\u6b21\u306e\u5217\u3092\u691c\u7d22\u300d<\/li>\n<\/ul>\n<p><strong><span class=\"f-marker-g\">\u5b9f\u884c\u7d50\u679c\uff1a<\/span><\/strong><\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/\u5b9f\u884c\u7d50\u679c3.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2023\/05\/\u5b9f\u884c\u7d50\u679c3.png\" alt=\"\u5b9f\u884c\u7d50\u679c3\" width=\"206\" height=\"186\" class=\"alignnone size-full wp-image-4013\" \/><\/a><\/p>\n<p>1\u56de\u76ee\u306e\u691c\u7d22\u30aa\u30d7\u30b7\u30e7\u30f3\u300c\u90e8\u5206\u691c\u7d22\u300d\u304c\u6b8b\u3063\u3066\u3044\u308b\u305f\u3081\u3001\u300c\u6771\u4eac\u90fd\u300d\u304c\u691c\u7d22\u7d50\u679c\u3068\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002\u4f7f\u7528\u3059\u308b\u305f\u3073\u306b\u3001\u6bce\u56de\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u660e\u793a\u7684\u306b\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<h2><span id=\"i-3\">\uff13\uff0e\u6700\u5f8c\u306b<\/span><\/h2>\n<p><span>Find<\/span>\u30e1\u30bd\u30c3\u30c9\u306f\u3001\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u660e\u793a\u7684\u306b\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u7528\u9014\u304c\u5e83\u304c\u308a\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ecxel\u306e\u6a19\u6e96\u6a5f\u80fd\u3067\u3042\u308b\u691c\u7d22\u6a5f\u80fd\u3092\u4f7f\u3063\u305f\u3053\u3068\u306f\u3042\u308a\u307e\u3059\u304b\uff1f ExcelVBA\u3067\u3082\u4f3c\u305f\u51e6\u7406\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001Find\u30e1\u30bd\u30c3\u30c9\u306e\u57fa\u672c\u7684\u306a\u89e3\u8aac\u3092\u884c\u3063\u3066\u3044\u304d\u307e\u3059\u3002 \u76ee\u6b21\uff11\uff0eVBA\u306eFind\u30e1\u30bd\u30c3\u30c9\u306b\u3064\u3044\u3066\uff11-\uff11\uff0e [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":4014,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[18],"acf":[],"_links":{"self":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/4007"}],"collection":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/comments?post=4007"}],"version-history":[{"count":8,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/4007\/revisions"}],"predecessor-version":[{"id":6131,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/4007\/revisions\/6131"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/media\/4014"}],"wp:attachment":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/media?parent=4007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/categories?post=4007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}