{"id":119,"date":"2024-09-10T08:48:51","date_gmt":"2024-09-10T05:48:51","guid":{"rendered":"http:\/\/safakyuce.com.tr\/?p=119"},"modified":"2024-09-10T08:50:32","modified_gmt":"2024-09-10T05:50:32","slug":"excel-vba-kod-parcalari","status":"publish","type":"post","link":"https:\/\/safakyuce.com.tr\/?p=119","title":{"rendered":"Excel VBA kod par\u00e7alar\u0131"},"content":{"rendered":"\n<p>Bu yaz\u0131da Excel VBA ile kod yazarken en \u00e7ok kulland\u0131\u011f\u0131m kod \u00f6beklerini ekliyorum. Kendi yazd\u0131\u011f\u0131m yada ba\u015fka bir kaynaktan buldu\u011fum olabilir. Tamam\u0131 basit \u015feyler olabilir, direk kopyala yap\u0131\u015ft\u0131r yapt\u0131\u011f\u0131n\u0131zda \u00e7al\u0131\u015fmayabilir, bu kodlar yerine daha h\u0131zl\u0131 ve mant\u0131kl\u0131 olan \u00f6bekler olabilir&#8230;<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Sayfay\u0131 de\u011fi\u015fkene atama;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Dim t As Worksheet\nDim s As Worksheet\nSet t = Sheets(\"xxx\")<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Son sutun numaras\u0131;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sc = s.Cells(1, Columns.Count + 1).End(xlToLeft).Column \u00a0 \u00a0 'son sutun<\/code><\/pre>\n\n\n\n<p>Son sat\u0131r numaras\u0131;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sr = s.Cells(Rows.Count + 1, 1).End(xlUp).Row \u00a0 \u00a0 \u00a0 'son satir<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Sayfay\u0131 kitab\u0131n sonuna kopyala;<\/p>\n\n\n\n<p>\u00d6nce kopyalanacak sayfay\u0131 &#8220;t&#8221; de\u011fi\u015fkenine ata. Sonra kopyalanm\u0131\u015f sayfay\u0131 &#8220;t&#8221; de\u011fi\u015fkenine ata <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Set t = ActiveSheet\nt.Copy After:=Sheets(ActiveWorkbook.Sheets.Count)\n\nSet t = Sheets(ActiveWorkbook.Sheets.Count)<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Makroyu h\u0131zland\u0131rmak i\u00e7in;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>basla:\nclc = Application.Calculation\nApplication.EnableEvents = False\nApplication.ScreenUpdating = False\nApplication.Calculation = xlCalculationManual\n\n'\n'\n'\n'\n\ncikis:\nApplication.ScreenUpdating = True\nApplication.EnableEvents = True\nApplication.Calculation = clc<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bu yaz\u0131da Excel VBA ile kod yazarken en \u00e7ok kulland\u0131\u011f\u0131m kod \u00f6beklerini ekliyorum. Kendi yazd\u0131\u011f\u0131m yada ba\u015fka bir kaynaktan buldu\u011fum olabilir. Tamam\u0131 basit \u015feyler olabilir,&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"https:\/\/safakyuce.com.tr\/?p=119\">Devam\u0131n\u0131 okuyun<span class=\"screen-reader-text\">Excel VBA kod par\u00e7alar\u0131<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[64,1],"tags":[60,61,63,62],"class_list":["post-119","post","type-post","status-publish","format-standard","hentry","category-excel","category-genel","tag-excel","tag-excel-vba","tag-excel-vba-son-satir","tag-excel-vba-son-sutun","entry"],"_links":{"self":[{"href":"https:\/\/safakyuce.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/safakyuce.com.tr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/safakyuce.com.tr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/safakyuce.com.tr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/safakyuce.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=119"}],"version-history":[{"count":3,"href":"https:\/\/safakyuce.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/119\/revisions"}],"predecessor-version":[{"id":122,"href":"https:\/\/safakyuce.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/119\/revisions\/122"}],"wp:attachment":[{"href":"https:\/\/safakyuce.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/safakyuce.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/safakyuce.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}