{"id":7826,"date":"2022-09-10T12:56:46","date_gmt":"2022-09-10T07:26:46","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/"},"modified":"2022-09-10T12:56:46","modified_gmt":"2022-09-10T07:26:46","slug":"solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/","title":{"rendered":"[Solved] I can&#8217;t get my VBA Excel Macro to stop at the end of the row"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-21560420\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"21560420\" data-parentid=\"21557146\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>If I understand your question correctly: for each Cell in H2:H98, you&#8217;re looking for a match in A2:A98. It won&#8217;t necessarily be on the same row. If you find a match in Column A, you want to take the value from Column B and put it in Column I on the same row as the search value we just looked for. In this case, this code will work:<\/p>\n<pre><code>Option Explicit\nSub Test()\n\nDim ws          As Worksheet\nDim srcRng      As Range        '' Source range\nDim schRng      As Range        '' Search range\nDim c           As Range\nDim search      As Range\n\nSet ws = ThisWorkbook.Sheets(1)\nSet srcRng = ws.Range(\"H2:H98\")\nSet schRng = ws.Range(\"A2:A98\")\n\nFor Each c In srcRng     '' Iterate through your source range\n    Set search = schRng.Find(c.Value, LookIn:=xlValues, SearchDirection:=xlNext)     '' Find the value from column H in column A\n    If Not search Is Nothing Then\n        c.Offset(, 1).Copy search.Offset(, 1)   '' Get the value from column B, from the same row as the value it found in column A\n                                                '' Then paste that value in column I, on the same row as the value we searched for from column H\n    End If\nNext c\n<\/code><\/pre>\n<p>GoTo statements are generally (<strong>generally, not always<\/strong>) very, <strong>very<\/strong> bad practice. Especially in this kind of situation. You don&#8217;t need them, it just makes your code convoluted.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">6<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved I can&#8217;t get my VBA Excel Macro to stop at the end of the row <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] If I understand your question correctly: for each Cell in H2:H98, you&#8217;re looking for a match in A2:A98. It won&#8217;t necessarily be on the same row. If you find a match in Column A, you want to take the value from Column B and put it in Column I on the same row as &#8230; <a title=\"[Solved] I can&#8217;t get my VBA Excel Macro to stop at the end of the row\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/\" aria-label=\"More on [Solved] I can&#8217;t get my VBA Excel Macro to stop at the end of the row\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[400,401],"class_list":["post-7826","post","type-post","status-publish","format-standard","hentry","category-solved","tag-excel","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] I can&#039;t get my VBA Excel Macro to stop at the end of the row - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] I can&#039;t get my VBA Excel Macro to stop at the end of the row - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] If I understand your question correctly: for each Cell in H2:H98, you&#8217;re looking for a match in A2:A98. It won&#8217;t necessarily be on the same row. If you find a match in Column A, you want to take the value from Column B and put it in Column I on the same row as ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-10T07:26:46+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] I can&#8217;t get my VBA Excel Macro to stop at the end of the row\",\"datePublished\":\"2022-09-10T07:26:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/\"},\"wordCount\":136,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"excel\",\"vba\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/\",\"name\":\"[Solved] I can't get my VBA Excel Macro to stop at the end of the row - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-10T07:26:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] I can&#8217;t get my VBA Excel Macro to stop at the end of the row\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] I can't get my VBA Excel Macro to stop at the end of the row - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] I can't get my VBA Excel Macro to stop at the end of the row - JassWeb","og_description":"[ad_1] If I understand your question correctly: for each Cell in H2:H98, you&#8217;re looking for a match in A2:A98. It won&#8217;t necessarily be on the same row. If you find a match in Column A, you want to take the value from Column B and put it in Column I on the same row as ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/","og_site_name":"JassWeb","article_published_time":"2022-09-10T07:26:46+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] I can&#8217;t get my VBA Excel Macro to stop at the end of the row","datePublished":"2022-09-10T07:26:46+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/"},"wordCount":136,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["excel","vba"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/","url":"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/","name":"[Solved] I can't get my VBA Excel Macro to stop at the end of the row - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-10T07:26:46+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-i-cant-get-my-vba-excel-macro-to-stop-at-the-end-of-the-row\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] I can&#8217;t get my VBA Excel Macro to stop at the end of the row"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/7826","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=7826"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/7826\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=7826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=7826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=7826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}