{"id":5798,"date":"2017-04-04T01:49:18","date_gmt":"2017-04-04T01:49:18","guid":{"rendered":"https:\/\/wordherd.io\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\/"},"modified":"2017-04-04T01:49:18","modified_gmt":"2017-04-04T01:49:18","slug":"%e4%bd%bf%e7%94%a8-vba-%e5%9c%a8-excel-%e4%b8%ad%e7%a1%ae%e5%ae%9a%e9%a1%b5%e9%9d%a2%e5%a4%a7%e5%b0%8f%e5%92%8c%e6%89%80%e9%9c%80%e5%88%97%e5%ae%bd%e5%ba%a6","status":"publish","type":"post","link":"https:\/\/wordherd.io\/zh\/blog\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\/","title":{"rendered":"\u4f7f\u7528 VBA \u5728 Excel \u4e2d\u786e\u5b9a\u9875\u9762\u5927\u5c0f\u548c\u6240\u9700\u5217\u5bbd\u5ea6"},"content":{"rendered":"<p>\u7531\u4e8e Excel \u4e3b\u8981\u662f\u4e00\u6b3e\u7528\u4e8e\u77e5\u8bc6\u8bc4\u4f30\u7684\u8f6f\u4ef6\uff0c\u56e0\u6b64\u5176\u663e\u793a\u5de5\u5177\u901a\u5e38\u4f1a\u53d7\u5230\u6bd4\u8f83\u7684\u5f71\u54cd\u3002\u4f8b\u5982\uff0c\u60a8\u7684\u6570\u636e\u901a\u5e38\u5305\u542b\u5404\u79cd\u5927\u5c0f\u7684\u6587\u672c\uff0c\u53ef\u80fd\u8d85\u8fc7\u6253\u5370\u673a\u7684\u6253\u5370\u8303\u56f4\u3002<\/p>\n<p>\u672c\u6587\u5c06\u4ecb\u7ecd\u5982\u4f55\u8ba1\u7b97\u6b63\u786e\u7684\u5217\u5bbd\uff0c\u4ee5\u786e\u4fdd\u6587\u672c\u5185\u5bb9\u5728\u9875\u9762\u4e2d\u4fdd\u6301\u4e00\u81f4\u3002\u901a\u5e38\u60c5\u51b5\u4e0b\uff0c\u5217\u6570\u901a\u5e38\u4e3a 2 \u5217\uff0c\u800c\u7b2c\u4e09\u5217\u5219\u663e\u793a\u8bc4\u8bba\uff1a<\/p>\n<p><pre>\n<br>\u6807\u9898\u3001\u65e5\u671f\u3001\u5907\u6ce8\n<br><\/pre>\n<\/p>\n<p>\u867d\u7136 Excel \u6709\u4e00\u4e9b\u53ef\u7528\u7684\u5de5\u5177\uff0c\u4f8b\u5982\u81ea\u52a8\u8c03\u6574\u529f\u80fd\uff0c\u4f46\u6ca1\u6709\u4ec0\u4e48\u80fd\u6bd4\u5f97\u4e0a\u4eb2\u81ea\u8d1f\u8d23\u81ea\u5df1\u7684\u8f6f\u4ef6\uff0c\u624d\u80fd\u5f97\u5230\u81ea\u5df1\u60f3\u8981\u7684\u6700\u7ec8\u7ed3\u679c\u3002<\/p>\n<p>\u6211\u4eec\u5c06\u7f16\u5199\u4e00\u4e9b\u4ee3\u7801\u6765\u8ba1\u7b97\u53ef\u6253\u5370\u7eb8\u5f20\u7684\u5bbd\u5ea6\uff0c\u8fd9\u6837\u5c31\u53ef\u4ee5\u51b3\u5b9a\u5217\u5bbd\uff0c\u4ee5\u786e\u4fdd\u73af\u4fdd\u6253\u5370\u3002<\/p>\n<p><strong>\u8ba1\u7b97\u7f51\u9875\u4e0a\u7684\u6253\u5370\u533a\u57df<\/strong><\/p>\n<p>\u5176\u4e2d\u4e00\u4e2a\u95ee\u9898\u662f\uff0c\u7f51\u9875\u6d4b\u91cf\u3001\u8fb9\u8ddd\u548c\u5217\u7684\u6d4b\u91cf\u65b9\u6cd5\u4e0d\u4e00\u81f4\uff0c\u6211\u4eec\u9700\u8981\u5728\u786e\u5b9a\u6b63\u786e\u7684\u5217\u5bbd\u5ea6\u4e4b\u524d\u6807\u51c6\u5316\u8fd9\u4e9b\u65b9\u6cd5\u3002<\/p>\n<p>\u4e00\u79cd\u66f4\u5148\u8fdb\u7684\u6280\u672f\u662f\u5c06\u6240\u6709\u6a21\u578b\u8f6c\u6362\u4e3a\u56e0\u5b50\uff0c\u800c\u4e0d\u662f\u82f1\u5bf8\u6216\u5398\u7c73\u3002\u7f51\u9875\u7684\u5bbd\u5ea6\u6700\u521d\u4ee5\u82f1\u5bf8\u8868\u793a\uff0c\u7136\u540e\u8f6c\u6362\u6210\u56e0\u5b50\uff0c\u800c\u5de6\u8fb9\u548c\u53f3\u8fb9\u7684\u8fb9\u8ddd\u5219\u5df2\u7ecf\u4ee5\u56e0\u5b50\u8868\u793a\u4e86\u3002<\/p>\n<p><pre>\n<br>pgWid = Utility.InchesToPoints(ActiveSheet.PageSetup.PaperSize)\n<br>leftMargin = ActiveSheet.PageSetup.LeftMargin\n<br>rightMargin = ActiveSheet.PageSetup.RightMargin\n<br><\/pre>\n<\/p>\n<p>\u968f\u540e\uff0c\u7b80\u5355\u7684\u6570\u5b66\u8fd0\u7b97\u5c31\u80fd\u5f97\u51fa\u6253\u5370\u673a\u7684\u5c3a\u5bf8\uff0c\u800c\u6211\u4eec\u9700\u8981\u5c06\u7b2c\u4e09\u5217\u7684\u6570\u636e\u4e0e\u6b64\u76f8\u5339\u914d\u3002<\/p>\n<p><pre>\n<br>content material = pgWid - leftMargin - rightMargin\n<br>col3=content-columns(1).Width - columns(2).Width\n<br><\/pre>\n<\/p>\n<p>\u73b0\u5728\u6211\u4eec\u5728\u56e0\u5b50\u4e2d\u5df2\u7ecf\u6709\u4e86\u7b2c\u4e09\u5217\u6240\u9700\u7684\u5bbd\u5ea6\u4e86\uff0c\u8fd9\u771f\u662f\u592a\u68d2\u4e86\uff0c\u6b64\u5916\uff0c\u7b2c\u4e09\u5217\u7684\u5bbd\u5ea6\u4e5f\u662f <strong>\u6ca1\u6709<\/strong> \u5728 Excel \u4e2d\uff0c\u8fd9\u4e9b\u503c\u4ee5\u56e0\u5b50\u8868\u793a\uff0c\u4f46\u5b83\u4eec\u4ee5\u5b57\u4f53\u5927\u5c0f\u4e3a\u57fa\u7840\uff0c\u57fa\u4e8e\u4e2a\u4eba\u5355\u4f4d\u8ba1\u7b97\u3002\u56e0\u6b64\uff0c\u6211\u4eec\u5c06\u521b\u5efa\u4e00\u4e2a\u5143\u7d20\uff0c\u6839\u636e\u5355\u5143\u683c 1 \u4e2d\u7684\u6d4b\u91cf\u503c\u6765\u8f6c\u6362\u5bbd\u5ea6\u3002<\/p>\n<p><pre>\n<br>'\u56e0\u7d20\u4e2d\u7684\u5bbd\u5ea6\u2014\u2014\u4ec5\u4f9b\u5b66\u4e60\u4e4b\u7528\u3002\n<br>pts = \u5217(1).\u5bbd\u5ea6\n<br>'Excel \u4e2d\u7684\u6d4b\u91cf\u5355\u4f4d\u662f\u201c\u5bbd\u5ea6\u201d\n<br>wd = Columns(1).ColumnWidth\n<br>\u95ee\u9898 = \u70b9\u6570 \/ \u4ef7\u503c\n<br>col3 = col3 \/issue\n<br><\/pre>\n<\/p>\n<p>\u6700\u540e\uff0c\u6211\u4eec\u8fd8\u9700\u8981\u8003\u8651\u7b2c\u4e09\u5217\u7684\u5bbd\u5ea6\uff0c\u5e76\u5728\u4ee5\u4e0b\u4ee3\u7801\u4e2d\u4f7f\u7528 wrap \u5c5e\u6027\u6765\u8bbe\u7f6e\u5bbd\u5ea6\u3002 <em>\u771f\u7684<\/em> \u5e76\u4e14\u884c\u5cf0\u503c\u4f1a\u81ea\u52a8\u5339\u914d\u3002<\/p>\n<p><pre>\n<br>\u5217\uff08\u7b2c\u4e09\u5217\uff09\u3002\u5217\u5bbd = col3\n<br>\u7b2c(3)\u884c\uff0cwrapText=true\n<br>\u884c\uff083\uff09\u3002\u6574\u884c\u81ea\u52a8\u8c03\u6574\n<br><\/pre>\n<\/p>\n<p><strong>\u6458\u8981<\/strong><\/p>\n<p>\u867d\u7136\u8ba1\u7b97\u7f51\u9875\u5c3a\u5bf8\u548c\u5217\u7684\u8ba1\u7b97\u901a\u5e38\u6bd4\u8f83\u590d\u6742\uff0c\u4f46\u503c\u5f97\u575a\u6301\u4e0b\u53bb\u3002\u5bf9\u7535\u5b50\u8868\u683c\u4e2d\u4e0d\u540c\u7ec4\u4ef6\u7684\u8ba1\u7b97\u65b9\u5f0f\u7684\u6df1\u5165\u4e86\u89e3\u6709\u52a9\u4e8e\u66f4\u8f7b\u677e\u5730\u51c6\u5907\u6253\u5370\u6570\u636e\u3002<\/p>\n<div class=\"source\"><a href=\"http:\/\/ezinearticles.com\/?Using-VBA-To-Determine-The-Page-Size-And-Required-Column-Width-In-Excel&#038;id=7305778\">\u6765\u6e90<\/a> \u7531 <a href=\"http:\/\/ezinearticles.com\/expert\/Andy_L_Gibson\/1382722\">\u5b89\u8fea\u00b7L\u00b7\u5409\u5e03\u68ee<\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>As a result of Excel is primarily an software for knowledge evaluation, generally its presentation instruments endure by comparability. For instance, generally your knowledge has textual content of assorted size and may exceed the obtainable printing house. This text will present you find out how to calculate the proper column width to make sure the [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"categories":[15],"tags":[200,595],"builders":[],"industry":[],"platform":[],"class_list":["post-5798","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-wordpress","tag-wordpress-tutorial"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Using VBA To Determine The Page Size And Required Column Width In Excel - WordHerd WordPress Migration<\/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:\/\/wordherd.io\/zh\/\u535a\u5ba2\/\u4f7f\u7528-vba-\u5728-excel-\u4e2d\u786e\u5b9a\u9875\u9762\u5927\u5c0f\u548c\u6240\u9700\u5217\u5bbd\u5ea6\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using VBA To Determine The Page Size And Required Column Width In Excel - WordHerd WordPress Migration\" \/>\n<meta property=\"og:description\" content=\"As a result of Excel is primarily an software for knowledge evaluation, generally its presentation instruments endure by comparability. For instance, generally your knowledge has textual content of assorted size and may exceed the obtainable printing house. This text will present you find out how to calculate the proper column width to make sure the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wordherd.io\/zh\/\u535a\u5ba2\/\u4f7f\u7528-vba-\u5728-excel-\u4e2d\u786e\u5b9a\u9875\u9762\u5927\u5c0f\u548c\u6240\u9700\u5217\u5bbd\u5ea6\/\" \/>\n<meta property=\"og:site_name\" content=\"WordHerd WordPress Migration\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/wordherdio\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-04T01:49:18+00:00\" \/>\n<meta name=\"author\" content=\"WordHerd\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@wordherdio\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"WordHerd\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\\\/\"},\"author\":{\"name\":\"WordHerd\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#\\\/schema\\\/person\\\/373419b97c0fbc45a3a16462bdba0fac\"},\"headline\":\"Using VBA To Determine The Page Size And Required Column Width In Excel\",\"datePublished\":\"2017-04-04T01:49:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\\\/\"},\"wordCount\":384,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/#organization\"},\"keywords\":[\"WordPress\",\"wordpress tutorial\"],\"articleSection\":[\"WordPress\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/wordherd.io\\\/blog\\\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\\\/\",\"url\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\\\/\",\"name\":\"Using VBA To Determine The Page Size And Required Column Width In Excel - WordHerd WordPress Migration\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/#website\"},\"datePublished\":\"2017-04-04T01:49:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wordherd.io\\\/blog\\\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wordherd.io\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using VBA To Determine The Page Size And Required Column Width In Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#website\",\"url\":\"https:\\\/\\\/wordherd.io\\\/\",\"name\":\"WordHerd WordPress Migration\",\"description\":\"Website Migration Services\",\"publisher\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wordherd.io\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#organization\",\"name\":\"WordHerd WordPress Migration\",\"url\":\"https:\\\/\\\/wordherd.io\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/wordherd.io\\\/wp-content\\\/uploads\\\/wordherd-trademark.png\",\"contentUrl\":\"https:\\\/\\\/wordherd.io\\\/wp-content\\\/uploads\\\/wordherd-trademark.png\",\"width\":1000,\"height\":315,\"caption\":\"WordHerd WordPress Migration\"},\"image\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#\\\/schema\\\/person\\\/373419b97c0fbc45a3a16462bdba0fac\",\"name\":\"WordHerd\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g\",\"caption\":\"WordHerd\"},\"sameAs\":[\"https:\\\/\\\/wordherd.io\",\"https:\\\/\\\/www.facebook.com\\\/wordherdio\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/wordherd\",\"https:\\\/\\\/x.com\\\/wordherdio\"],\"url\":\"https:\\\/\\\/wordherd.io\\\/zh\\\/blog\\\/author\\\/wordherd\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528 VBA \u5728 Excel \u4e2d\u786e\u5b9a\u9875\u9762\u5927\u5c0f\u548c\u6240\u9700\u5217\u5bbd\u5ea6 - WordHerd WordPress \u8fc1\u79fb","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:\/\/wordherd.io\/zh\/\u535a\u5ba2\/\u4f7f\u7528-vba-\u5728-excel-\u4e2d\u786e\u5b9a\u9875\u9762\u5927\u5c0f\u548c\u6240\u9700\u5217\u5bbd\u5ea6\/","og_locale":"zh_CN","og_type":"article","og_title":"Using VBA To Determine The Page Size And Required Column Width In Excel - WordHerd WordPress Migration","og_description":"As a result of Excel is primarily an software for knowledge evaluation, generally its presentation instruments endure by comparability. For instance, generally your knowledge has textual content of assorted size and may exceed the obtainable printing house. This text will present you find out how to calculate the proper column width to make sure the [&hellip;]","og_url":"https:\/\/wordherd.io\/zh\/\u535a\u5ba2\/\u4f7f\u7528-vba-\u5728-excel-\u4e2d\u786e\u5b9a\u9875\u9762\u5927\u5c0f\u548c\u6240\u9700\u5217\u5bbd\u5ea6\/","og_site_name":"WordHerd WordPress Migration","article_author":"https:\/\/www.facebook.com\/wordherdio\/","article_published_time":"2017-04-04T01:49:18+00:00","author":"WordHerd","twitter_card":"summary_large_image","twitter_creator":"@wordherdio","twitter_misc":{"\u4f5c\u8005":"WordHerd","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wordherd.io\/blog\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\/#article","isPartOf":{"@id":"https:\/\/wordherd.io\/blog\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\/"},"author":{"name":"WordHerd","@id":"https:\/\/wordherd.io\/#\/schema\/person\/373419b97c0fbc45a3a16462bdba0fac"},"headline":"Using VBA To Determine The Page Size And Required Column Width In Excel","datePublished":"2017-04-04T01:49:18+00:00","mainEntityOfPage":{"@id":"https:\/\/wordherd.io\/blog\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\/"},"wordCount":384,"commentCount":0,"publisher":{"@id":"https:\/\/wordherd.io\/#organization"},"keywords":["WordPress","wordpress tutorial"],"articleSection":["WordPress"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/wordherd.io\/blog\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/wordherd.io\/blog\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\/","url":"https:\/\/wordherd.io\/blog\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\/","name":"\u4f7f\u7528 VBA \u5728 Excel \u4e2d\u786e\u5b9a\u9875\u9762\u5927\u5c0f\u548c\u6240\u9700\u5217\u5bbd\u5ea6 - WordHerd WordPress \u8fc1\u79fb","isPartOf":{"@id":"https:\/\/wordherd.io\/#website"},"datePublished":"2017-04-04T01:49:18+00:00","breadcrumb":{"@id":"https:\/\/wordherd.io\/blog\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wordherd.io\/blog\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/wordherd.io\/blog\/using-vba-to-determine-the-page-size-and-required-column-width-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wordherd.io\/"},{"@type":"ListItem","position":2,"name":"Using VBA To Determine The Page Size And Required Column Width In Excel"}]},{"@type":"WebSite","@id":"https:\/\/wordherd.io\/#website","url":"https:\/\/wordherd.io\/","name":"WordHerd WordPress \u79fb\u8f6c","description":"\u7f51\u7ad9\u8fc1\u79fb\u670d\u52a1","publisher":{"@id":"https:\/\/wordherd.io\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wordherd.io\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":"Organization","@id":"https:\/\/wordherd.io\/#organization","name":"WordHerd WordPress \u79fb\u8f6c","url":"https:\/\/wordherd.io\/","logo":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/wordherd.io\/#\/schema\/logo\/image\/","url":"https:\/\/wordherd.io\/wp-content\/uploads\/wordherd-trademark.png","contentUrl":"https:\/\/wordherd.io\/wp-content\/uploads\/wordherd-trademark.png","width":1000,"height":315,"caption":"WordHerd WordPress Migration"},"image":{"@id":"https:\/\/wordherd.io\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/wordherd.io\/#\/schema\/person\/373419b97c0fbc45a3a16462bdba0fac","name":"WordHerd","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/secure.gravatar.com\/avatar\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g","caption":"WordHerd"},"sameAs":["https:\/\/wordherd.io","https:\/\/www.facebook.com\/wordherdio\/","https:\/\/www.linkedin.com\/company\/wordherd","https:\/\/x.com\/wordherdio"],"url":"https:\/\/wordherd.io\/zh\/blog\/author\/wordherd\/"}]}},"_links":{"self":[{"href":"https:\/\/wordherd.io\/zh\/wp-json\/wp\/v2\/posts\/5798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordherd.io\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordherd.io\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordherd.io\/zh\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/wordherd.io\/zh\/wp-json\/wp\/v2\/comments?post=5798"}],"version-history":[{"count":0,"href":"https:\/\/wordherd.io\/zh\/wp-json\/wp\/v2\/posts\/5798\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordherd.io\/zh\/wp-json\/wp\/v2\/media?parent=5798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordherd.io\/zh\/wp-json\/wp\/v2\/categories?post=5798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordherd.io\/zh\/wp-json\/wp\/v2\/tags?post=5798"},{"taxonomy":"builders","embeddable":true,"href":"https:\/\/wordherd.io\/zh\/wp-json\/wp\/v2\/builders?post=5798"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/wordherd.io\/zh\/wp-json\/wp\/v2\/industry?post=5798"},{"taxonomy":"platform","embeddable":true,"href":"https:\/\/wordherd.io\/zh\/wp-json\/wp\/v2\/platform?post=5798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}