{"id":242,"date":"2013-01-08T06:52:12","date_gmt":"2013-01-08T04:52:12","guid":{"rendered":"http:\/\/excelvbatips.co.il\/?page_id=242"},"modified":"2018-06-13T00:20:27","modified_gmt":"2018-06-12T21:20:27","slug":"%d7%98%d7%99%d7%a4-%d7%9c%d7%a7%d7%91%d7%9c%d7%aa-%d7%a8%d7%a9%d7%99%d7%9e%d7%aa-%d7%94%d7%92%d7%99%d7%9c%d7%99%d7%95%d7%a0%d7%95%d7%aa-%d7%91%d7%a7%d7%95%d7%91%d7%a5-%d7%91%d7%90%d7%9e%d7%a6%d7%a2","status":"publish","type":"page","link":"https:\/\/excelvbatips.co.il\/?page_id=242","title":{"rendered":"\u05d8\u05d9\u05e4 \u05dc\u05e7\u05d1\u05dc\u05ea \u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea \u05d1\u05e7\u05d5\u05d1\u05e5 \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea \u05d0\u05e7\u05e1\u05dc VBA"},"content":{"rendered":"<h1>\u05d8\u05d9\u05e4 \u05dc\u05e7\u05d1\u05dc\u05ea \u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea \u05d1\u05e7\u05d5\u05d1\u05e5 \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea \u05d0\u05e7\u05e1\u05dc VBA<\/h1>\n<p>\u05d9\u05e9 \u05dc\u05da \u05e7\u05d5\u05d1\u05e5 \u05d0\u05e7\u05e1\u05dc \u05e2\u05dd \u05d4\u05e8\u05d1\u05d4 \u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea ?<\/p>\n<p>\u05e8\u05d5\u05e6\u05d4 \u05dc\u05e7\u05d1\u05dc \u05d0\u05ea \u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea \u05d1\u05e7\u05d5\u05d1\u05e5 \u05d0\u05e7\u05e1\u05dc?<\/p>\n<p>\u05db\u05d0\u05e9\u05e8 \u05d9\u05e9 \u05d4\u05e8\u05d1\u05d4 \u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea \u05d1\u05e7\u05d5\u05d1\u05e5 \u05d0\u05e7\u05e1\u05dc , \u05d9\u05db\u05d5\u05dc \u05dc\u05d4\u05d9\u05d5\u05ea \u05e0\u05d5\u05d7 \u05db\u05d0\u05e9\u05e8 \u05d9\u05e9 \u05e8\u05e9\u05d9\u05de\u05d4 \u05e9\u05dc \u05db\u05dc \u05d4\u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea , \u05de\u05d0\u05e4\u05e9\u05e8 \u05dc\u05db\u05ea\u05d5\u05d1 \u05ea\u05d9\u05e2\u05d5\u05d3 \u05dc\u05d9\u05d3 \u05e9\u05dd \u05db\u05dc \u05d2\u05d9\u05dc\u05d9\u05d5\u05df , \u05dc\u05d4\u05d3\u05e4\u05d9\u05e1 \u05d0\u05ea \u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea \u05d5\u05e2\u05d5\u05d3.<\/p>\n<p>\u05d1\u05d2\u05d9\u05dc\u05d9\u05d5\u05df \u05d1\u05e9\u05dd <strong>\u05e8\u05d9\u05db\u05d5\u05d6<\/strong> \u05d1\u05e7\u05d5\u05d1\u05e5 \u05d1\u05d5 \u05db\u05ea\u05d5\u05d1 \u05d4\u05de\u05d0\u05e7\u05e8\u05d5 \u05e0\u05e7\u05d1\u05dc \u05e8\u05e9\u05d9\u05de\u05ea \u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea \u05d1\u05e2\u05de\u05d5\u05d3\u05d4 A \u05d4\u05d7\u05dc \u05de\u05d4\u05ea\u05d0 A2<\/p>\n<p dir=\"ltr\">Sub sheets_list()<\/p>\n<blockquote dir=\"ltr\"><p>For i = 1 To ThisWorkbook.Sheets.Count<\/p><\/blockquote>\n<blockquote dir=\"ltr\"><p>ThisWorkbook.Sheets(&quot;\u05e8\u05d9\u05db\u05d5\u05d6&quot;).Cells(i + 1, 1) = Sheets(i).Name<\/p><\/blockquote>\n<blockquote dir=\"ltr\"><p>Next i<\/p><\/blockquote>\n<p dir=\"ltr\">End Sub<\/p>\n<p>\u05d0\u05e4\u05e9\u05e8 \u05dc\u05d4\u05d5\u05e1\u05d9\u05e3 \u05dc\u05de\u05d0\u05e7\u05e8\u05d5 VBA \u05e7\u05d5\u05d3 \u05dc\u05d4\u05d3\u05e4\u05e1\u05ea \u05d4\u05e8\u05e9\u05d9\u05de\u05d4.<\/p>\n<h2>\u05d1 \u05d4 \u05e6 \u05dc \u05d7 \u05d4<\/h2>\n","protected":false},"excerpt":{"rendered":"<p>\u05d8\u05d9\u05e4 \u05dc\u05e7\u05d1\u05dc\u05ea \u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea \u05d1\u05e7\u05d5\u05d1\u05e5 \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea \u05d0\u05e7\u05e1\u05dc VBA \u05d9\u05e9 \u05dc\u05da \u05e7\u05d5\u05d1\u05e5 \u05d0\u05e7\u05e1\u05dc \u05e2\u05dd \u05d4\u05e8\u05d1\u05d4 \u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea ? \u05e8\u05d5\u05e6\u05d4 \u05dc\u05e7\u05d1\u05dc \u05d0\u05ea \u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea \u05d1\u05e7\u05d5\u05d1\u05e5 \u05d0\u05e7\u05e1\u05dc? \u05db\u05d0\u05e9\u05e8 \u05d9\u05e9 \u05d4\u05e8\u05d1\u05d4 \u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea \u05d1\u05e7\u05d5\u05d1\u05e5 \u05d0\u05e7\u05e1\u05dc , \u05d9\u05db\u05d5\u05dc \u05dc\u05d4\u05d9\u05d5\u05ea \u05e0\u05d5\u05d7 \u05db\u05d0\u05e9\u05e8 \u05d9\u05e9 \u05e8\u05e9\u05d9\u05de\u05d4 \u05e9\u05dc \u05db\u05dc \u05d4\u05d2\u05d9\u05dc\u05d9\u05d5\u05e0\u05d5\u05ea , <span class=\"excerpt-dots\">&hellip;<\/span> <a class=\"more-link\" href=\"https:\/\/excelvbatips.co.il\/?page_id=242\"><span class=\"more-msg\">\u05d4\u05de\u05e9\u05da \u05e7\u05e8\u05d9\u05d0\u05d4 &larr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/pages\/242"}],"collection":[{"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=242"}],"version-history":[{"count":2,"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/pages\/242\/revisions"}],"predecessor-version":[{"id":338,"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/pages\/242\/revisions\/338"}],"wp:attachment":[{"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}