{"id":7365,"date":"2011-07-12T11:10:37","date_gmt":"2011-07-12T11:10:37","guid":{"rendered":"http:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/"},"modified":"2011-07-12T11:10:37","modified_gmt":"2011-07-12T11:10:37","slug":"sub-insert","status":"publish","type":"post","link":"https:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/","title":{"rendered":"Sub Insert()"},"content":{"rendered":"\u23f3 Approximate reading time: <\/span> < 1<\/span> min<\/span><\/span>

Ended up working on the Sony Viao all morning, its poor fan whirring like a twin-prop airplane, so I could execute this macro on the Big Data Set. Going to need a macro solution for the Macbook eventually, which would appear to require 1) figuring out Applescript, 2) trying Keyboard Maestro, or 3) making better use of the Bootcamp partition. For good keeping, today’s macro:<\/p>\n

Sub Insert()
\n'
\n' Insert Macro
\n' Macro recorded 7\/12\/2011 by Derek Mueller
\n'
\n' Keyboard Shortcut: Ctrl+w
\n'
\n ActiveCell.Offset(-1, 0).Range(\"A1:M1\").Select
\n Selection.Copy
\n ActiveCell.Offset(1).EntireRow.Insert
\n ActiveCell.Offset(1, 0).Range(\"A1\").Select
\n ActiveSheet.Paste
\n ActiveCell.Offset(0, 7).Range(\"A1\").Select
\n Application.CutCopyMode = False
\n ActiveCell.FormulaR1C1 = \"D\"
\n ActiveCell.Offset(0, 3).Range(\"A1\").Select
\n Application.CutCopyMode = False
\n ActiveCell.FormulaR1C1 = \" \"
\n ActiveCell.Offset(0, 1).Range(\"A1\").Select
\n Application.CutCopyMode = False
\n ActiveCell.FormulaR1C1 = \"NAME\"
\n ActiveCell.Offset(1, -11).Range(\"A1\").Select
\nEnd Sub<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

\u23f3 Approximate reading time: <\/span> < 1<\/span> min<\/span><\/span>Ended up working on the Sony Viao all morning, its poor fan whirring like a twin-prop airplane, so I could execute this macro on the Big Data Set. Going to need a macro solution for the Macbook eventually, which would appear to require 1) figuring out Applescript, 2) trying Keyboard Maestro, or 3) making better…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[170],"tags":[152,2667,234,2166,2668,130,2669],"class_list":["post-7365","post","type-post","status-publish","format-standard","hentry","category-method","tag-data","tag-dataset","tag-macro","tag-method","tag-procedure","tag-process","tag-shortcut"],"yoast_head":"\nSub Insert() - Earth Wide Moth<\/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:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sub Insert() - Earth Wide Moth\" \/>\n<meta property=\"og:description\" content=\"\u23f3 Approximate reading time: < 1 minEnded up working on the Sony Viao all morning, its poor fan whirring like a twin-prop airplane, so I could execute this macro on the Big Data Set. Going to need a macro solution for the Macbook eventually, which would appear to require 1) figuring out Applescript, 2) trying Keyboard Maestro, or 3) making better...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/\" \/>\n<meta property=\"og:site_name\" content=\"Earth Wide Moth\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/derek.mueller\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/derek.mueller\" \/>\n<meta property=\"article:published_time\" content=\"2011-07-12T11:10:37+00:00\" \/>\n<meta name=\"author\" content=\"Derek Mueller\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Derek Mueller\" \/>\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:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2011\\\/07\\\/12\\\/sub-insert\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2011\\\/07\\\/12\\\/sub-insert\\\/\"},\"author\":{\"name\":\"Derek Mueller\",\"@id\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/#\\\/schema\\\/person\\\/66fc5e80a62f53057760790b1cfeb24b\"},\"headline\":\"Sub Insert()\",\"datePublished\":\"2011-07-12T11:10:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2011\\\/07\\\/12\\\/sub-insert\\\/\"},\"wordCount\":65,\"publisher\":{\"@id\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/#\\\/schema\\\/person\\\/66fc5e80a62f53057760790b1cfeb24b\"},\"keywords\":[\"data\",\"dataset\",\"macro\",\"method\",\"procedure\",\"process\",\"shortcut\"],\"articleSection\":[\"Methods\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2011\\\/07\\\/12\\\/sub-insert\\\/\",\"url\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2011\\\/07\\\/12\\\/sub-insert\\\/\",\"name\":\"Sub Insert() - Earth Wide Moth\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/#website\"},\"datePublished\":\"2011-07-12T11:10:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2011\\\/07\\\/12\\\/sub-insert\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2011\\\/07\\\/12\\\/sub-insert\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2011\\\/07\\\/12\\\/sub-insert\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sub Insert()\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/#website\",\"url\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/\",\"name\":\"Earth Wide Moth\",\"description\":\"\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/#\\\/schema\\\/person\\\/66fc5e80a62f53057760790b1cfeb24b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/#\\\/schema\\\/person\\\/66fc5e80a62f53057760790b1cfeb24b\",\"name\":\"Derek Mueller\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.earthwidemoth.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/cropped-bmartwork.png?fit=1220%2C480\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.earthwidemoth.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/cropped-bmartwork.png?fit=1220%2C480\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.earthwidemoth.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/cropped-bmartwork.png?fit=1220%2C480\",\"width\":1220,\"height\":480,\"caption\":\"Derek Mueller\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.earthwidemoth.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/cropped-bmartwork.png?fit=1220%2C480\"},\"sameAs\":[\"http:\\\/\\\/www.derekmueller.net\\\/\",\"https:\\\/\\\/www.facebook.com\\\/derek.mueller\",\"https:\\\/\\\/www.instagram.com\\\/dereknmueller\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dnmueller\"],\"url\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/author\\\/dmueller\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sub Insert() - Earth Wide Moth","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:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/","og_locale":"en_US","og_type":"article","og_title":"Sub Insert() - Earth Wide Moth","og_description":"\u23f3 Approximate reading time: < 1 minEnded up working on the Sony Viao all morning, its poor fan whirring like a twin-prop airplane, so I could execute this macro on the Big Data Set. Going to need a macro solution for the Macbook eventually, which would appear to require 1) figuring out Applescript, 2) trying Keyboard Maestro, or 3) making better...","og_url":"https:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/","og_site_name":"Earth Wide Moth","article_publisher":"https:\/\/www.facebook.com\/derek.mueller","article_author":"https:\/\/www.facebook.com\/derek.mueller","article_published_time":"2011-07-12T11:10:37+00:00","author":"Derek Mueller","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Derek Mueller","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/#article","isPartOf":{"@id":"https:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/"},"author":{"name":"Derek Mueller","@id":"http:\/\/www.earthwidemoth.com\/blog\/#\/schema\/person\/66fc5e80a62f53057760790b1cfeb24b"},"headline":"Sub Insert()","datePublished":"2011-07-12T11:10:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/"},"wordCount":65,"publisher":{"@id":"http:\/\/www.earthwidemoth.com\/blog\/#\/schema\/person\/66fc5e80a62f53057760790b1cfeb24b"},"keywords":["data","dataset","macro","method","procedure","process","shortcut"],"articleSection":["Methods"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/","url":"https:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/","name":"Sub Insert() - Earth Wide Moth","isPartOf":{"@id":"http:\/\/www.earthwidemoth.com\/blog\/#website"},"datePublished":"2011-07-12T11:10:37+00:00","breadcrumb":{"@id":"https:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.earthwidemoth.com\/blog\/2011\/07\/12\/sub-insert\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.earthwidemoth.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Sub Insert()"}]},{"@type":"WebSite","@id":"http:\/\/www.earthwidemoth.com\/blog\/#website","url":"http:\/\/www.earthwidemoth.com\/blog\/","name":"Earth Wide Moth","description":"","publisher":{"@id":"http:\/\/www.earthwidemoth.com\/blog\/#\/schema\/person\/66fc5e80a62f53057760790b1cfeb24b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.earthwidemoth.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/www.earthwidemoth.com\/blog\/#\/schema\/person\/66fc5e80a62f53057760790b1cfeb24b","name":"Derek Mueller","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/i0.wp.com\/www.earthwidemoth.com\/blog\/wp-content\/uploads\/2023\/04\/cropped-bmartwork.png?fit=1220%2C480","url":"https:\/\/i0.wp.com\/www.earthwidemoth.com\/blog\/wp-content\/uploads\/2023\/04\/cropped-bmartwork.png?fit=1220%2C480","contentUrl":"https:\/\/i0.wp.com\/www.earthwidemoth.com\/blog\/wp-content\/uploads\/2023\/04\/cropped-bmartwork.png?fit=1220%2C480","width":1220,"height":480,"caption":"Derek Mueller"},"logo":{"@id":"https:\/\/i0.wp.com\/www.earthwidemoth.com\/blog\/wp-content\/uploads\/2023\/04\/cropped-bmartwork.png?fit=1220%2C480"},"sameAs":["http:\/\/www.derekmueller.net\/","https:\/\/www.facebook.com\/derek.mueller","https:\/\/www.instagram.com\/dereknmueller\/","https:\/\/www.youtube.com\/user\/dnmueller"],"url":"https:\/\/www.earthwidemoth.com\/blog\/author\/dmueller\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7tdGk-1UN","jetpack-related-posts":[{"id":7110,"url":"https:\/\/www.earthwidemoth.com\/blog\/2007\/08\/28\/porter-etal-ins\/","url_meta":{"origin":7365,"position":0},"title":"Porter, et al., “Institutional Critique”","author":"Derek Mueller","date":"August 28, 2007","format":false,"excerpt":"Porter, James E., Patricia Sullivan, Stuart Blythe, Jeffrey Grabill, and Libby Miles. \"Institutional Critique: A Rhetorical Methodology for Change.\" CCC 51.4 (2000): 610-642. To the extent that institutions are rhetorical constructs, rhetoric can be deployed to enact change across a range of institutional scales, from the micro to the macro.\u2026","rel":"","context":"In "Models"","block_context":{"text":"Models","link":"https:\/\/www.earthwidemoth.com\/blog\/category\/models\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6095,"url":"https:\/\/www.earthwidemoth.com\/blog\/2004\/05\/22\/porter-et-al-20\/","url_meta":{"origin":7365,"position":1},"title":"Porter, et al., 2001, “Institutional Critique”","author":"Derek Mueller","date":"May 22, 2004","format":false,"excerpt":"\u00a0Porter, James, et. al. \"Institutional Critique: A Rhetorical Methodology for Change.\" CCC 51 (2000): 610-642. Big Idea Institutions can be changed through rhetorical activism.\u00a0 Porter and company develop broad model for institutional critique driven by rhetoricians as agents for change and pomo geographical interrogations to stage institutional dynamics (needing change).\u00a0\u2026","rel":"","context":"In "Reading Notes"","block_context":{"text":"Reading Notes","link":"https:\/\/www.earthwidemoth.com\/blog\/category\/reading_notes\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6409,"url":"https:\/\/www.earthwidemoth.com\/blog\/2005\/09\/17\/lost-prepremier\/","url_meta":{"origin":7365,"position":2},"title":"Lost Prepremiere","author":"Derek Mueller","date":"September 17, 2005","format":false,"excerpt":"No, I don't know what's coming in Wednesday's premiere of Lost, but I confess that I'm distracted by how much I'm looking forward to it. And Steven Johnson's entry yesterday along with ABC's commercials roil my anticipation even more. The genius of Lost is that its mysteries are fractal: at\u2026","rel":"","context":"In "Media"","block_context":{"text":"Media","link":"https:\/\/www.earthwidemoth.com\/blog\/category\/media_massage\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6827,"url":"https:\/\/www.earthwidemoth.com\/blog\/2007\/09\/21\/10x\/","url_meta":{"origin":7365,"position":3},"title":"10x","author":"Derek Mueller","date":"September 21, 2007","format":false,"excerpt":"I might be on the down slope in this second chapter. I've been writing about scale, aerating the idea of \"textual altitude.\" I begin with conventional notions of scale, like those we find in traditional, basic cartography. Drawing on a couple of geography resources, I brush the term in two\u2026","rel":"","context":"In "Dissertation"","block_context":{"text":"Dissertation","link":"https:\/\/www.earthwidemoth.com\/blog\/category\/dissertation\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":7048,"url":"https:\/\/www.earthwidemoth.com\/blog\/2006\/10\/04\/russell-rethink-1\/","url_meta":{"origin":7365,"position":4},"title":"Russell, “Rethinking Genre in School and Society”","author":"Derek Mueller","date":"October 4, 2006","format":false,"excerpt":"Russell, David R. \"Rethinking Genre in School and Society: An Activity Theory Analysis.\" Written Communication 14 (1997): 504-54. Russell proposes that the convergence of activity theory and North American genre theory (read largely through Bazernman's genre systems) yields a useful blend for researchers concerned with accounting for the ties between\u2026","rel":"","context":"In "Tools-in-use"","block_context":{"text":"Tools-in-use","link":"https:\/\/www.earthwidemoth.com\/blog\/category\/toolsinuse\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6376,"url":"https:\/\/www.earthwidemoth.com\/blog\/2005\/08\/16\/from-this-point\/","url_meta":{"origin":7365,"position":5},"title":"From This Point On","author":"Derek Mueller","date":"August 16, 2005","format":false,"excerpt":"What started with making a few notes last night for an informal talk I have coming up next week unraveled into a what'sit: #FFFF00 Path. I was overcome by the impulse; you know, the grab-a-camera work-avoiding impulse lurking beneath the surface of practically everything in late August. Pre-apologies: if you\u2026","rel":"","context":"In "Travelog"","block_context":{"text":"Travelog","link":"https:\/\/www.earthwidemoth.com\/blog\/category\/travelog\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/posts\/7365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/comments?post=7365"}],"version-history":[{"count":0,"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/posts\/7365\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/media?parent=7365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/categories?post=7365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/tags?post=7365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}