{"id":512,"date":"2017-09-12T10:56:40","date_gmt":"2017-09-12T08:56:40","guid":{"rendered":"http:\/\/markusheinemann.com\/wordpress\/?p=512"},"modified":"2017-09-12T10:56:40","modified_gmt":"2017-09-12T08:56:40","slug":"zeilen-und-spalten-einer-tabelle-zaehlen","status":"publish","type":"post","link":"https:\/\/markusheinemann.com\/wordpress\/?p=512","title":{"rendered":"Zeilen und Spalten einer Tabelle z\u00e4hlen"},"content":{"rendered":"<p><strong>Anzahl Zeilen und Spalten einer Exceltabelle z\u00e4hlen<\/strong><\/p>\n<pre><code>\r\nanzahlzeilen = Worksheets(\"Tabelle1\").Cells(Rows.Count, 1).End(xlUp).Row\r\nanzahlSpalten = Worksheets(1).Cells(1, Worksheets(1).Columns.Count).End(xlToLeft).Column\r\n<em>'[Worksheets(1)=Worksheets(\"Tabelle1\")= Tabelle in der gez\u00e4hlt werden soll]<\/em>\r\n<\/pre>\n<p><\/code><br \/>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anzahl Zeilen und Spalten einer Exceltabelle z\u00e4hlen anzahlzeilen = Worksheets(&#8222;Tabelle1&#8220;).Cells(Rows.Count, 1).End(xlUp).Row anzahlSpalten = Worksheets(1).Cells(1, Worksheets(1).Columns.Count).End(xlToLeft).Column &#8218;[Worksheets(1)=Worksheets(&#8222;Tabelle1&#8220;)= Tabelle in der gez\u00e4hlt werden soll] &nbsp;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-512","post","type-post","status-publish","format-standard","hentry","category-vba-codebeispiele"],"_links":{"self":[{"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=512"}],"version-history":[{"count":1,"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/512\/revisions"}],"predecessor-version":[{"id":514,"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/512\/revisions\/514"}],"wp:attachment":[{"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}