{"id":12187,"date":"2014-04-05T10:24:28","date_gmt":"2014-04-05T10:24:28","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=3266"},"modified":"2022-08-06T22:05:51","modified_gmt":"2022-08-06T22:05:51","slug":"array-to-range-excel-macro","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/","title":{"rendered":"Spreading an Array values across Columns in Excel – VBA"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.16″ da_disable_devices=”off|off|off” global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]All my avid readers from Computer Programming backgrounds must be thinking is it a big deal? Like other programming languages use loop<\/a><\/strong><\/em> to traverse all the values of an array and spread them across rows or column. Right?
\n 
\nIf you are thinking so… you are absolutely right. You can do it using the loop.
\n 
\nBut what if I tell you that there is a very easy and faster way to do so? Excited??
\n 
\nGenerally, as a developer, we tend to forget the performance aspect while coding… be it a code for a small task or a big software. Performance matters. None of us like the below screen while watching an exciting Cricket Match on Internet or a Movie etc. Then why ignore the performance aspect??
\n <\/p>\n

\"Buffering

Buffering Delay<\/p><\/div>\n

 
\nSo let’s learn some faster technique to solve the above task. In the above task performance does not really matters when Array is smaller in size. But when Array size is bigger (like in Thousands..) then you will realize the performance issue.<\/p>\n

 
\nSo without wasting any more time let’s come to the point. In this article I will give you both the codes to spread the values of an array towards Rows or Columns. At the end of the article you will find a downloadable which will show you the performance difference.<\/p>\n

1. Slower Method – Array values across columns – Using Loop<\/h3>\n

Below is the traditional code to traverse an array value using loop and using this all the values of an array will be spread across columns.
\n <\/p>\n

\n\nSub SpreadUsingLoop()\n'This function will spread the array values using For loop\n    \n    Dim myArr(10000) As Variant\n    Dim TimeDuration As Long\n    Dim StartTime As Date\n    Dim EndTime As Date\n    \n    StartTime = Now 'Start time is captured here\n    \n'fill values in this array\n    For i = 0 To UBound(myArr) - 1\n        myArr(i) = \"This is my data \" & i\n    Next\n'myArr has 5000 values in it.\n'to spread this 5000 values, here we will use loop\n    Rows(6).Clear\n    \n    For i = 0 To UBound(myArr) - 1\n        Cells(6, i + 1).Value = myArr(i)\n    Next\n    EndTime = Now  ' End time is captured\n'Calculate the total time duration in seconds\n    TimeDuration = DateDiff(\"s\", CDate(StartTime), CDate(EndTime))\n'Show the time taken in Message Box\n    MsgBox TimeDuration & \" Second(s)\"\nEnd Sub\n\n<\/code><\/pre>\n
2. Faster Method – Array values across columns – Using Array to Range<\/h3>\n
Below is the BEST <\/strong>way to spread an array values across columns.<\/p>\n
 <\/p>\n
\nSub SpreadUsingArrayToRange()\n    \n'This function will spread the array values using For Array to Range\n    \n    Dim myArr(10000) As Variant\n    Dim TimeDuration As Long\n    Dim StartTime As Date\n    Dim EndTime As Date\n    \n    StartTime = Now 'Start time is captured here\n    \n'fill values in this array\n    For i = 0 To UBound(myArr) - 1\n        myArr(i) = \"This is my data \" & i\n    Next\n'myArr has 5000 values in it.\n'to spread this 10000 values, here we will use array to range method\n    Rows(11).Clear\n    Range(Cells(11, 1), Cells(11, UBound(myArr))).Value = myArr\n    EndTime = Now  ' End time is captured\n'Calculate the total time duration in Seconds\n    TimeDuration = DateDiff(\"s\", CDate(StartTime), CDate(EndTime))\n'Show the time taken in Message Box\n    MsgBox TimeDuration & \" Second(s)\"\n    \nEnd Sub\n<\/code><\/pre>\n
 <\/p>\n
How is the second method better? <\/h3>\n
 i) Simpler in coding – Single line code <\/h3>\n
In the second method you need not to write a looping code of 3 lines with a traversing variable “i”. Thus it makes your coding easy, short and understandable.<\/p>\n
 ii) Faster – Better Performance <\/h3>\n
This is the Major benefit of the second method. This method is way faster than the First one. For 5000 Records you can see the difference by running both the codes. My observation is that – First code always takes 2 to 3 seconds for 5000 records while the second method completes in ZERO seconds.[\/et_pb_text][et_pb_cta title=”FREE Download – View Performance of Spread Arrays across columns” button_url=”\/excel\/wp-content\/downloads\/Array_Traverse_-_Better_performance.xlsm” button_text=”Download Now” _builder_version=”4.17.6″ _module_preset=”a50a16dd-d05f-4ea2-acab-1468d2e4010e” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]To see the performance and play around with the code, you can download the below excel workbook with both the codes with a User Interface button.<\/p>\n
\"VBA
VBA Animation to see – Array Traverse Performance<\/p><\/div>[\/et_pb_cta][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"
All my avid readers from Computer Programming backgrounds must be thinking is it a big deal? Like other programming languages use loop to traverse all the values of an array and spread them across rows or column. Right?   If you are thinking so… you are absolutely right. You can do it using the loop. […]<\/p>\n","protected":false},"author":45,"featured_media":242477,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"All my avid readers from Computer Programming backgrounds must be thinking is it a big deal? Like other programming languages use loop<\/a><\/strong><\/em> to traverse all the values of an array and spread them across rows or column. Right?\r\n\u00a0\r\nIf you are thinking so... you are absolutely right. You can do it using the loop.\r\n\u00a0\r\nBut what if I tell you that there is a very easy and faster way to do so? Excited??\r\n\u00a0\r\nGenerally, as a developer, we tend to forget the performance aspect while coding... be it a code for a small task or a big software. Performance matters. None of us like the below screen while watching an exciting Cricket Match on Internet or a Movie etc. Then why ignore the performance aspect??\r\n\u00a0\r\n\r\n[caption id=\"attachment_242472\" align=\"aligncenter\" width=\"570\"]\"Buffering Buffering Delay[\/caption]\r\n\r\n\u00a0\r\nSo let's learn some faster technique to solve the above task. In the above task performance does not really matters when Array is smaller in size. But when Array size is bigger (like in Thousands..) then you will realize the performance issue.\r\n\r\n\u00a0\r\nSo without wasting any more time let's come to the point. In this article I will give you both the codes to spread the values of an array towards Rows or Columns. At the end of the article you will find a downloadable which will show you the performance difference.\r\n\r\n
1. Slower Method - Array values across columns - Using Loop<\/h3>\r\nBelow is the traditional code to traverse an array value using loop and using this all the values of an array will be spread across columns.\r\n\u00a0\r\n
\r\n\r\nSub SpreadUsingLoop()\r\n'This function will spread the array values using For loop\r\n    \r\n    Dim myArr(10000) As Variant\r\n    Dim TimeDuration As Long\r\n    Dim StartTime As Date\r\n    Dim EndTime As Date\r\n    \r\n    StartTime = Now 'Start time is captured here\r\n    \r\n'fill values in this array\r\n    For i = 0 To UBound(myArr) - 1\r\n        myArr(i) = \"This is my data \" & i\r\n    Next\r\n'myArr has 5000 values in it.\r\n'to spread this 5000 values, here we will use loop\r\n    Rows(6).Clear\r\n    \r\n    For i = 0 To UBound(myArr) - 1\r\n        Cells(6, i + 1).Value = myArr(i)\r\n    Next\r\n    EndTime = Now  ' End time is captured\r\n'Calculate the total time duration in seconds\r\n    TimeDuration = DateDiff(\"s\", CDate(StartTime), CDate(EndTime))\r\n'Show the time taken in Message Box\r\n    MsgBox TimeDuration & \" Second(s)\"\r\nEnd Sub\r\n\r\n<\/code><\/pre>\r\n\r\n\r\n
2. Faster Method - Array values across columns - Using Array to Range<\/h3>\r\nBelow is the BEST <\/strong>way to spread an array values across columns.\r\n\r\n\u00a0\r\n\r\n
\r\nSub SpreadUsingArrayToRange()\r\n    \r\n'This function will spread the array values using For Array to Range\r\n    \r\n    Dim myArr(10000) As Variant\r\n    Dim TimeDuration As Long\r\n    Dim StartTime As Date\r\n    Dim EndTime As Date\r\n    \r\n    StartTime = Now 'Start time is captured here\r\n    \r\n'fill values in this array\r\n    For i = 0 To UBound(myArr) - 1\r\n        myArr(i) = \"This is my data \" & i\r\n    Next\r\n'myArr has 5000 values in it.\r\n'to spread this 10000 values, here we will use array to range method\r\n    Rows(11).Clear\r\n    Range(Cells(11, 1), Cells(11, UBound(myArr))).Value = myArr\r\n    EndTime = Now  ' End time is captured\r\n'Calculate the total time duration in Seconds\r\n    TimeDuration = DateDiff(\"s\", CDate(StartTime), CDate(EndTime))\r\n'Show the time taken in Message Box\r\n    MsgBox TimeDuration & \" Second(s)\"\r\n    \r\nEnd Sub\r\n<\/code><\/pre>\r\n\r\n\u00a0\r\n
How is the second method better? <\/h3>\r\n\r\n
 i) Simpler in coding - Single line code <\/h3>\r\nIn the second method you need not to write a looping code of 3 lines with a traversing variable \"i\". Thus it makes your coding easy, short and understandable.\r\n
 ii) Faster - Better Performance <\/h3>\r\nThis is the Major benefit of the second method. This method is way faster than the First one. For 5000 Records you can see the difference by running both the codes. My observation is that - First code always takes 2 to 3 seconds for 5000 records while the second method completes in ZERO seconds.\r\n\u00a0\r\n\r\n
 To see the performance and play around the code, you can download the below excel workbook with both the codes with a User Interface button.\r\n\u00a0\r\n\r\n[caption id=\"attachment_242474\" align=\"alignnone\" width=\"1512\"]\"VBA VBA Animation to see - Array Traverse Performance[\/caption]\r\n\r\n\"Download<\/a>","_et_gb_content_width":"","footnotes":""},"categories":[1246,1675,1676,1678,1682],"tags":[],"class_list":["post-12187","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-macro","category-excel-macro-for-beginners","category-excel-tips","category-interesting-vba-functions","category-popular-articles"],"yoast_head":"\nSpreading an Array values across Columns in Excel - VBA - Let's excel in Excel<\/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:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Spreading an Array values across Columns in Excel - VBA\" \/>\n<meta property=\"og:description\" content=\"All my avid readers from Computer Programming backgrounds must be thinking is it a big deal? Like other programming languages use loop to traverse all the values of an array and spread them across rows or column. Right?   If you are thinking so... you are absolutely right. You can do it using the loop. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2014-04-05T10:24:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-06T22:05:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/04\/spread-an-Array-values-across-Columns.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Spreading an Array values across Columns in Excel – VBA\",\"datePublished\":\"2014-04-05T10:24:28+00:00\",\"dateModified\":\"2022-08-06T22:05:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/\"},\"wordCount\":616,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/04\/spread-an-Array-values-across-Columns.png\",\"articleSection\":[\"Excel Macro\",\"Excel Macro Tutorial\",\"Excel Tips\",\"Interesting VBA Functions\",\"Popular Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/\",\"name\":\"Spreading an Array values across Columns in Excel - VBA - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/04\/spread-an-Array-values-across-Columns.png\",\"datePublished\":\"2014-04-05T10:24:28+00:00\",\"dateModified\":\"2022-08-06T22:05:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/04\/spread-an-Array-values-across-Columns.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/04\/spread-an-Array-values-across-Columns.png\",\"width\":400,\"height\":250,\"caption\":\"SPREAD AN ARRAY OF VALUES ACROSS COLUMNS\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Spreading an Array values across Columns in Excel – VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Spreading an Array values across Columns in Excel - VBA - Let's excel in Excel","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:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/","og_locale":"en_US","og_type":"article","og_title":"Spreading an Array values across Columns in Excel - VBA","og_description":"All my avid readers from Computer Programming backgrounds must be thinking is it a big deal? Like other programming languages use loop to traverse all the values of an array and spread them across rows or column. Right?   If you are thinking so... you are absolutely right. You can do it using the loop. […]","og_url":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2014-04-05T10:24:28+00:00","article_modified_time":"2022-08-06T22:05:51+00:00","og_image":[{"width":400,"height":250,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/04\/spread-an-Array-values-across-Columns.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Spreading an Array values across Columns in Excel – VBA","datePublished":"2014-04-05T10:24:28+00:00","dateModified":"2022-08-06T22:05:51+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/"},"wordCount":616,"commentCount":4,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/04\/spread-an-Array-values-across-Columns.png","articleSection":["Excel Macro","Excel Macro Tutorial","Excel Tips","Interesting VBA Functions","Popular Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/","url":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/","name":"Spreading an Array values across Columns in Excel - VBA - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/04\/spread-an-Array-values-across-Columns.png","datePublished":"2014-04-05T10:24:28+00:00","dateModified":"2022-08-06T22:05:51+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/04\/spread-an-Array-values-across-Columns.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/04\/spread-an-Array-values-across-Columns.png","width":400,"height":250,"caption":"SPREAD AN ARRAY OF VALUES ACROSS COLUMNS"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2014\/04\/array-to-range-excel-macro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Spreading an Array values across Columns in Excel – VBA"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12187"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12187"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12187\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242477"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}