{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Molly","ExcelForumsourabhg98","Sht_1","Pupils Dashboard"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":7,"n_cols":1,"rows_kept":7}
["Sub FormatCodeWSP()"]
["'formats code remarks to green for paste into formums"]
["'copy code into A1 on Sheet1"]
["Dim LastRow As Long"]
["Dim FilePath As String"]
["Dim MyTxtFile"]
["FilePath = \"C:\\temp1.html\""]

{"sheet":"Molly","index":1,"n_rows":95,"n_cols":22,"rows_kept":95}
["10   Name","Tot","Tot","Tot",null,null,"Hi","Molly","Gerry"]
["20   joe",60,52,23,null,null,"Yous","are","Welcome"]
["30   luis",24,100,81]
["40   frank",95,74,24]
["50   anna",67,58,55,null,null,"Rory","appears","to","Test ","ying","\"PikeFoxRick\""]
["60   mike",56,63,83,null,null,"be","Playing","with","Note","does","not"]
["70   violet",39,49,49,null,null,"his ","Tool ","Today","have ","The ","XL2007",null,null,"order","product","qty",1,2,3,10,30]
["80   grace",28,26,{"$f":"(2*68)/2","v":68},null,null,"Newest","So","Has","Cell","Text","Color",null,null,1001,"orange",3,"A","AA","AAA","AAAAAAAAAA","AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"]
["90   '",{"$nulls":5},"The","XL2007","Cell","problem","that","some",null,null,1002,"berry red",1]
["100   '",{"$nulls":5},"Text","Color","Problem","similar","codes","have",null,null,1002,"berry red",1]
["110   Hightlight ( Select )  Spreadsheet Range you want copied to the Clipboard. Then Run the MAIN CODE. Then paste that in the Forum Reply Editor window. It should look like a lot of BB Code. When Posted it should come out as a table representative of the selected Spreadsheet Range.  Test here :    http://www.excelfox.com/forum/forumdisplay.php/17-Test-Area      or here:     http://www.excelforum.com/development-testing-forum/   or not here:      http://www.mrexcel.com/forum/test-here/",{"$nulls":13},1002,"berry purple",1]
[{"$nulls":14},1003,"apple red",1]
[{"$nulls":5},"Hi","Ford, Select these two cells and run code Sub BB_Table_Clipboard_PikeFoxAlan()",{"$nulls":7},1003,"apple green",2]
[{"$nulls":5},"PikeCalibri","Fooaarrnst Arial Narrow",{"$nulls":7},1004,"berry red",1]
[{"$nulls":5},"Verdana","Batang",{"$nulls":7},1004,"apple red",1]
[]
[{"$nulls":5},"ADD-Ins from   http://www.mrexcel.com/forum/about-board/864035-bbcode-border-help-3.html#post4199420"]
[null,"ABC1234A",{"$f":"LEFT(B18,3)&SUM(MID(0&B18,LARGE(ISNUMBER(--MID(B18,ROW(INDIRECT(\"1:\"&LEN(B18))),1))*ROW(INDIRECT(\"1:\"&LEN(B18))),ROW(INDIRECT(\"1:\"&LEN(B18))))+1,1)*10^(ROW(INDIRECT(\"1:\"&LEN(B18)))-1))","v":"ABC1234"},null,null,"https://app.box.com/s/boxjrj2wmlren3tgqqnamzxknnpwyaut"]
[null,"ABC1234AC","ABC1234",null,null,"https://app.box.com/s/x8bqg7cil2xnqyyo07v8gwt5zpiebxta"]
[null,"ABC1234AD","ABC1234",null,null,"https://app.box.com/s/7v5no8t18qqzjwyfqtv1xo5elsyba3o6"]
[null,"ABC1234B","ABC1234",null,null,"https://app.box.com/s/oa1zouz1ksm68yevndee6yi1v1o0qmmm"]
[null,"ABC1234CCC","ABC1234"]
[null,"ABC1234AA","ABC1234",null,null,"Typically they \"land\" somewhere like this….     C:\\Users\\Elston\\AppData\\Roaming\\Microsoft\\AddIns"]
[]
[{"$nulls":5},"Gerry Site ADD-In"]
[{"$nulls":5},"http://www.mrexcel.com/forum/about-board/864035-bbcode-border-help.html"]
[{"$nulls":5},"http://www.forumexcel.it/forum/16-test-dei-vostri-post/274-test-code-tags-and-bb-code-testare-codice-tag-e-codice-bb#post1576"]
[{"$nulls":5},"http://www.forumexcel.it/forum/17-componenti-aggiuntivi-amp-link-utili/212-immagini-per-intervalli-con-il-bbcode",{"$nulls":11},"Test","Marcelo's","\"Stand alone Code\""]
[{"$nulls":5},"https://www.dropbox.com/s/jk066gw113sj97e/Range%20to%20BBcode%20v0.5.xlam?dl=0",{"$nulls":11},{"$f":"ROW(2:3)","v":2},"Test"]
[{"$nulls":17},3,null,"Testying"]
[{"$nulls":5},"This File"]
[{"$nulls":5},"https://app.box.com/s/zhz7awdag4nl1zs6564s9zzcwp50e4w9"]
[]
[{"$nulls":5},"Excel Forum"]
[{"$nulls":5},"JBeaucaire "]
[{"$nulls":5},"http://www.excelforum.com/tips-and-tutorials/1089404-posting-an-html-table-in-a-forum-thread.html"]
[{"$nulls":5},"http://www.excelforum.com/the-water-cooler/1127943-tags-for-coloring-table-cells-for-excelforum.html"]
[{"$nulls":5},"http://www.excelforum.com/suggestions-for-improvement/949916-how-to-post-a-range-headers-and-data-17.html#post4355361"]
[{"$nulls":5},"http://www.excelforum.com/showthread.php?t=1086445"]
[{"$nulls":5},"http://www.excelforum.com/excel-programming-vba-macros/1135724-compare-and-find-missing-rows-in-two-sheets-with-different-headings-and-formats-5.html#post4399581"]
[{"$nulls":5},"http://www.excelforum.com/the-water-cooler/1068075-just-testing-img-cannot-do-it-in-test-forum-as-img-is-off-there-no-reply-needed-2.html#post4109080"]
[{"$nulls":5},"https://www.excelforum.com/development-testing-forum/1161667-messin-round-just-ignore-me.html"]
[]
[{"$nulls":5},"PikeFoxRick"]
[{"$nulls":5},"http://www.excelfox.com/forum/f13/bbcode-table-2077/"]
[{"$nulls":5},"http://www.ozgrid.com/forum/showthread.php?t=198172&page=2&p=763613#post763613"]
[{"$nulls":5},"http://www.ozgrid.com/forum/showthread.php?t=198172&page=2&p=763370#post763370"]
[{"$nulls":5},"http://www.excelfox.com/forum/showthread.php/2077-BBCode-Table?p=9801#post9801"]
[]
[{"$nulls":5},"RecentPosts"]
[{"$nulls":5},"http://www.mrexcel.com/forum/about-board/942937-forum-tool-add-bad-code-2.html"]
[{"$nulls":5},"http://www.excelfox.com/forum/showthread.php/2077-BBCode-Table?p=9805#post9805"]
{"$rows_empty":16}
[{"$nulls":3},87,24,62,97,12,47,33,77]
[{"$nulls":3},48,90,44,10,91,51,18,65]
[{"$nulls":3},65,61,69,96,84,54,13,92]
[{"$nulls":3},72,94,96,83,71,47,22,25]
[{"$nulls":3},27,94,74,21,13,31,27,76]
[{"$nulls":3},25,46,52,14,95,32,90,92]
[{"$nulls":3},54,29,53,17,45,20,10,81]
[{"$nulls":3},84,11,74,28,33,45,52,10]
[{"$nulls":3},76,55,56,91,88,76,49,26]
[{"$nulls":3},10,69,20,51,11,74,37,73]
[{"$nulls":3},46,25,94,94,53,68,57,19]
[{"$nulls":3},90,93,89,41,26,11,25,99]
[{"$nulls":3},94,61,24,29,54,85,81,20]
[]
[]
[]
[]
[null,null,"Name","Date","Score",null,"Name","Date","Score"]
[null,null,"P_Tang","2015-01-01",90,null,"P_Tang","P-Tang","Rory 1"]
[null,null,"P-Tang","2015-07-01",86,null,"OLE","WigyWam","Rory 2",null,"t"]
[null,null,"OLE","2015-12-28",88,null,"Biscuit Barrel","Wonk","Molly"]
[null,null,"WigyWam","2015-01-01",88,null,"Thanks","Reg","Wolly"]
[null,null,"Biscuit Barrel","2015-07-01",90,null,"A .Font and a .DisplayFormat","Too Much,  maybe?","WTF Wop"]
[null,null,"Du","2015-12-28",90,null,"Thanks","2015-12-28",90]
[null,null,"WTF","2015-01-01",92,null,"WTF","Reg",92]
[null,null,"MollyWolly","2015-07-01",86,null,"MollyWolly","2015-07-01",86]
[null,null,"Wop","2015-12-28",88,null,"Wonk","2015-12-28",88]

{"sheet":"ExcelForumsourabhg98","index":2,"n_rows":52,"n_cols":46,"rows_kept":52}
["Great.","I see Yous","did not","need any of","the ","Add-Ins","or ","Codes.",{"$nulls":3},"Darkred","Red","Orange","Yellow","Lightgreen","Skyblue","Blue","DarkBlue","Violet","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$f":"\"[th=bgcolor:\"&L1&\"][COLOR=\"&W1&\"]\"&A1&\"[/COLOR][/th]\"","v":"[th=bgcolor:Darkred][COLOR=Black]Great.[/COLOR][/th]"},"[th=bgcolor:Red][COLOR=Black]I see Yous[/COLOR][/th]","[th=bgcolor:Orange][COLOR=Black]did not[/COLOR][/th]","[th=bgcolor:Yellow][COLOR=Black]need any of[/COLOR][/th]","[th=bgcolor:Lightgreen][COLOR=Black]the [/COLOR][/th]","[th=bgcolor:Skyblue][COLOR=Black]Add-Ins[/COLOR][/th]","[th=bgcolor:Blue][COLOR=Black]or [/COLOR][/th]","[th=bgcolor:DarkBlue][COLOR=Black]Codes.[/COLOR][/th]","[th=bgcolor:Violet][COLOR=Black][/COLOR][/th]",null,null,{"$f":"IF(COUNTBLANK(AH1:AR1)=11,\"\",\"[TR]\"&AH1&AI1&AJ1&AK1&AL1&AM1&AN1&AO1&AP1&AQ1&AR1&\"[/TR]\")","v":"[TR][th=bgcolor:Darkred][COLOR=Black]Great.[/COLOR][/th][th=bgcolor:Red][COLOR=Black]I see Yous[/COLOR][/th][th=bgcolor:Orange][COLOR=Black]did not[/COLOR][/th][th=bgcolor:Yellow][COLOR=Black]need any of[/COLOR][/th][th=bgcolor:Lightgreen][COLOR=Black]the [/COLOR][/th][th=bgcolor:Skyblue][COLOR=Black]Add-Ins[/COLOR][/th][th=bgcolor:Blue][COLOR=Black]or [/COLOR][/th][th=bgcolor:DarkBlue][COLOR=Black]Codes.[/COLOR][/th][th=bgcolor:Violet][COLOR=Black][/COLOR][/th][/TR]"}]
["In fact","it was just","a quick","Wonk ","that ","was","needed","so ",{"$nulls":3},"White","White","White","White","White","White","White","White","Violet","White","White","Darkred","Red","Black","Black","Black","Black","Black","Black","Black","Black","Black","[th=bgcolor:White][COLOR=Darkred]In fact[/COLOR][/th]","[th=bgcolor:White][COLOR=Red]it was just[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]a quick[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]Wonk [/COLOR][/th]","[th=bgcolor:White][COLOR=Black]that [/COLOR][/th]","[th=bgcolor:White][COLOR=Black]was[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]needed[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]so [/COLOR][/th]","[th=bgcolor:Violet][COLOR=Black][/COLOR][/th]",null,null,{"$f":"IF(COUNTBLANK(AH2:AR2)=11,\"\",\"[TR]\"&AH2&AI2&AJ2&AK2&AL2&AM2&AN2&AO2&AP2&AQ2&AR2&\"[/TR]\")","v":"[TR][th=bgcolor:White][COLOR=Darkred]In fact[/COLOR][/th][th=bgcolor:White][COLOR=Red]it was just[/COLOR][/th][th=bgcolor:White][COLOR=Black]a quick[/COLOR][/th][th=bgcolor:White][COLOR=Black]Wonk [/COLOR][/th][th=bgcolor:White][COLOR=Black]that [/COLOR][/th][th=bgcolor:White][COLOR=Black]was[/COLOR][/th][th=bgcolor:White][COLOR=Black]needed[/COLOR][/th][th=bgcolor:White][COLOR=Black]so [/COLOR][/th][th=bgcolor:Violet][COLOR=Black][/COLOR][/th][/TR]"},"[size=2][Table=\"width:, class:head\"]"]
["as to","get ","that","little ","bit","of ","Syntax","Correct",{"$nulls":3},"White","White","White","White","White","White","White","White","Violet","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","[th=bgcolor:White][COLOR=Black]as to[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]get [/COLOR][/th]","[th=bgcolor:White][COLOR=Black]that[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]little [/COLOR][/th]","[th=bgcolor:White][COLOR=Black]bit[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]of [/COLOR][/th]","[th=bgcolor:White][COLOR=Black]Syntax[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]Correct[/COLOR][/th]","[th=bgcolor:Violet][COLOR=Black][/COLOR][/th]",null,null,"[TR][th=bgcolor:White][COLOR=Black]as to[/COLOR][/th][th=bgcolor:White][COLOR=Black]get [/COLOR][/th][th=bgcolor:White][COLOR=Black]that[/COLOR][/th][th=bgcolor:White][COLOR=Black]little [/COLOR][/th][th=bgcolor:White][COLOR=Black]bit[/COLOR][/th][th=bgcolor:White][COLOR=Black]of [/COLOR][/th][th=bgcolor:White][COLOR=Black]Syntax[/COLOR][/th][th=bgcolor:White][COLOR=Black]Correct[/COLOR][/th][th=bgcolor:Violet][COLOR=Black][/COLOR][/th][/TR]",{"$f":"AT2&AS1&AS2&AS3&AS4&AS5&AS6&AS7&AS8&AS9&AS10&AS11&AS12&AS13&AS14&AS15&AS16&AS17&AS18&AS19&AS20&AS21&\"[/table][/size]\"","v":"[size=2][Table=\"width:, class:head\"][TR][th=bgcolor:Darkred][COLOR=Black]Great.[/COLOR][/th][th=bgcolor:Red][COLOR=Black]I see Yous[/COLOR][/th][th=bgcolor:Orange][COLOR=Black]did not[/COLOR][/th][th=bgcolor:Yellow][COLOR=Black]need any of[/COLOR][/th][th=bgcolor:Lightgreen][COLOR=Black]the [/COLOR][/th][th=bgcolor:Skyblue][COLOR=Black]Add-Ins[/COLOR][/th][th=bgcolor:Blue][COLOR=Black]or [/COLOR][/th][th=bgcolor:DarkBlue][COLOR=Black]Codes.[/COLOR][/th][th=bgcolor:Violet][COLOR=Black][/COLOR][/th][/TR][TR][th=bgcolor:White][COLOR=Darkred]In fact[/COLOR][/th][th=bgcolor:White][COLOR=Red]it was just[/COLOR][/th][th=bgcolor:White][COLOR=Black]a quick[/COLOR][/th][th=bgcolor:White][COLOR=Black]Wonk [/COLOR][/th][th=bgcolor:White][COLOR=Black]that [/COLOR][/th][th=bgcolor:White][COLOR=Black]was[/COLOR][/th][th=bgcolor:White][COLOR=Black]needed[/COLOR][/th][th=bgcolor:White][COLOR=Black]so [/COLOR][/th][th=bgcolor:Violet][COLOR=Black][/COLOR][/th][/TR][TR][th=bgcolor:White][COLOR=Black]as to[/COLOR][/th][th=bgcolor:White][COLOR=Black]get [/COLOR][/th][th=bgcolor:White][COLOR=Black]that[/COLOR][/th][th=bgcolor:White][COLOR=Black]little [/COLOR][/th][th=bgcolor:White][COLOR=Black]bit[/COLOR][/th][th=bgcolor:White][COLOR=Black]of [/COLOR][/th][th=bgcolor:White][COLOR=Black]Syntax[/COLOR][/th][th=bgcolor:White][COLOR=Black]Correct[/COLOR][/th][th=bgcolor:Violet][COLOR=Black][/COLOR][/th][/TR][TR][th=bgcolor:White][COLOR=Black]Actually[/COLOR][/th][th=bgcolor:White][COLOR=Black]Yous [/COLOR][/th][th=bgcolor:White][COLOR=Black]have done[/COLOR][/th][th=bgcolor:White][COLOR=Black]all the [/COLOR][/th][th=bgcolor:White][COLOR=Black]work[/COLOR][/th][th=bgcolor:White][COLOR=Black]yourself[/COLOR][/th][th=bgcolor:White][COLOR=Black]and[/COLOR][/th][th=bgcolor:White][COLOR=Black]given[/COLOR][/th][th=bgcolor:Violet][COLOR=Black][/COLOR][/th][/TR][TR][th=bgcolor:White][COLOR=Black]us[/COLOR][/th][th=bgcolor:White][COLOR=Black]a very nice[/COLOR][/th][th=bgcolor:Yellow][COLOR=Black]Tool.[/COLOR][/th][th=bgcolor:White][COLOR=Black]Thankyou for[/COLOR][/th][th=bgcolor:White][COLOR=Black]making your[/COLOR][/th][th=bgcolor:Yellow][COLOR=Black]Tool [/COLOR][/th][th=bgcolor:White][COLOR=Black]here [/COLOR][/th][th=bgcolor:White][COLOR=Black]Public[/COLOR][/th][th=bgcolor:Violet][COLOR=Black][/COLOR][/th][/TR][TR][th=bgcolor:White][COLOR=Black]I am[/COLOR][/th][th=bgcolor:White][COLOR=Black]glad that[/COLOR][/th][th=bgcolor:White][COLOR=Black]that last [/COLOR][/th][th=bgcolor:White][COLOR=Black]quick Wonk[/COLOR][/th][th=bgcolor:White][COLOR=Black]on your[/COLOR][/th][th=bgcolor:Yellow][COLOR=Black]Tool [/COLOR][/th][th=bgcolor:White][COLOR=Black]got it[/COLOR][/th][th=bgcolor:Yellow][COLOR=Red]up.[/COLOR][/th][th=bgcolor:Violet][COLOR=Black][/COLOR][/th][/TR][/table][/size]"}]
["Actually","Yous ","have done","all the ","work","yourself","and","given",{"$nulls":3},"White","White","White","White","White","White","White","White","Violet","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","[th=bgcolor:White][COLOR=Black]Actually[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]Yous [/COLOR][/th]","[th=bgcolor:White][COLOR=Black]have done[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]all the [/COLOR][/th]","[th=bgcolor:White][COLOR=Black]work[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]yourself[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]and[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]given[/COLOR][/th]","[th=bgcolor:Violet][COLOR=Black][/COLOR][/th]",null,null,"[TR][th=bgcolor:White][COLOR=Black]Actually[/COLOR][/th][th=bgcolor:White][COLOR=Black]Yous [/COLOR][/th][th=bgcolor:White][COLOR=Black]have done[/COLOR][/th][th=bgcolor:White][COLOR=Black]all the [/COLOR][/th][th=bgcolor:White][COLOR=Black]work[/COLOR][/th][th=bgcolor:White][COLOR=Black]yourself[/COLOR][/th][th=bgcolor:White][COLOR=Black]and[/COLOR][/th][th=bgcolor:White][COLOR=Black]given[/COLOR][/th][th=bgcolor:Violet][COLOR=Black][/COLOR][/th][/TR]"]
["us","a very nice","Tool.","Thankyou for","making your","Tool ","here ","Public",{"$nulls":3},"White","White","Yellow","White","White","Yellow","White","White","Violet","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","[th=bgcolor:White][COLOR=Black]us[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]a very nice[/COLOR][/th]","[th=bgcolor:Yellow][COLOR=Black]Tool.[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]Thankyou for[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]making your[/COLOR][/th]","[th=bgcolor:Yellow][COLOR=Black]Tool [/COLOR][/th]","[th=bgcolor:White][COLOR=Black]here [/COLOR][/th]","[th=bgcolor:White][COLOR=Black]Public[/COLOR][/th]","[th=bgcolor:Violet][COLOR=Black][/COLOR][/th]",null,null,"[TR][th=bgcolor:White][COLOR=Black]us[/COLOR][/th][th=bgcolor:White][COLOR=Black]a very nice[/COLOR][/th][th=bgcolor:Yellow][COLOR=Black]Tool.[/COLOR][/th][th=bgcolor:White][COLOR=Black]Thankyou for[/COLOR][/th][th=bgcolor:White][COLOR=Black]making your[/COLOR][/th][th=bgcolor:Yellow][COLOR=Black]Tool [/COLOR][/th][th=bgcolor:White][COLOR=Black]here [/COLOR][/th][th=bgcolor:White][COLOR=Black]Public[/COLOR][/th][th=bgcolor:Violet][COLOR=Black][/COLOR][/th][/TR]"]
["I am","glad that","that last ","quick Wonk","on your","Tool ","got it","up.",{"$nulls":3},"White","White","White","White","White","Yellow","White","Yellow","Violet","White","White","Black","Black","Black","Black","Black","Black","Black","Red","Black","Black","Black","[th=bgcolor:White][COLOR=Black]I am[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]glad that[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]that last [/COLOR][/th]","[th=bgcolor:White][COLOR=Black]quick Wonk[/COLOR][/th]","[th=bgcolor:White][COLOR=Black]on your[/COLOR][/th]","[th=bgcolor:Yellow][COLOR=Black]Tool [/COLOR][/th]","[th=bgcolor:White][COLOR=Black]got it[/COLOR][/th]","[th=bgcolor:Yellow][COLOR=Red]up.[/COLOR][/th]","[th=bgcolor:Violet][COLOR=Black][/COLOR][/th]",null,null,"[TR][th=bgcolor:White][COLOR=Black]I am[/COLOR][/th][th=bgcolor:White][COLOR=Black]glad that[/COLOR][/th][th=bgcolor:White][COLOR=Black]that last [/COLOR][/th][th=bgcolor:White][COLOR=Black]quick Wonk[/COLOR][/th][th=bgcolor:White][COLOR=Black]on your[/COLOR][/th][th=bgcolor:Yellow][COLOR=Black]Tool [/COLOR][/th][th=bgcolor:White][COLOR=Black]got it[/COLOR][/th][th=bgcolor:Yellow][COLOR=Red]up.[/COLOR][/th][th=bgcolor:Violet][COLOR=Black][/COLOR][/th][/TR]"]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[{"$nulls":11},"White","White","White","White","White","White","White","White","White","White","White","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black","Black",{"$nulls":11},""]
[]
[]
[{"$nulls":11},"Index","Color"]
[]
[{"$nulls":11},192,"Darkred"]
[{"$nulls":11},255,"Red"]
[{"$nulls":11},49407,"Orange"]
[{"$nulls":11},65535,"Yellow"]
[{"$nulls":11},5296274,"Lightgreen"]
[{"$nulls":11},5287936,"Green"]
[{"$nulls":11},15773696,"Skyblue"]
[{"$nulls":11},12611584,"Blue"]
[{"$nulls":11},6299648,"DarkBlue"]
[{"$nulls":11},10498160,"Violet"]
[{"$nulls":11},16777215,"White"]
[{"$nulls":11},0,"Black"]
[]
["Check File In below Link ( Copied to this sheet )\nThis works for range A1:K21\nEnter some data in this range, like I have entered in A1:B2.\nNow, give some colors to these cells. You can even change the font colors.\nAfter entering data click the GO button. Select your desired range for which you create the table. Like A1:B2 in this case.\nThe macro would automatically create the tags and the CODE would be automatically copied to your clipboard.\nPaste the code in the posts at this forum."]
["http://www.excelforum.com/showthread.php?t=1127943&p=4325644&highlight=#post4324864"]
["http://www.excelforum.com/showthread.php?t=1086445#post4394573"]
["  Please [B]do not [/B]use images as we cannot copy them to a worksheet. "]
["[B]  Instead:"]
["[/B] [U][b] Either [/b][/U]"]
["use the Add-In Linked in my signature or similar tools to produce screenshots that we can copy. "]
["[url]http://www.excelforum.com/the-water-cooler/1127943-tags-for-coloring-table-cells-for-excelforum-2.html#post4354756[/url]"]
["[url]http://www.excelforum.com/suggestions-for-improvement/949916-how-to-post-a-range-headers-and-data-17.html[/url]"]
["[url]http://www.excelforum.com/showthread.php?t=1086445&p=4354867&highlight=#post4354867[/url]"]
["[url]http://www.excelfox.com/forum/showthread.php/2079-test-BB-Code?p=9804#post9804[/url]"]
["[url]http://www.mrexcel.com/forum/about-board/864035-bbcode-border-help.html[/url]"]
["[url]http://www.mrexcel.com/forum/about-board/857232-forum-tools-add-using-installing.html[/url]"]
["[url]http://www.forumexcel.it/forum/16-test-dei-vostri-post/274-test-code-tags-and-bb-code-testare-codice-tag-e-codice-bb#post1576[/url]"]

{"sheet":"Sht_1","index":3,"n_rows":3,"n_cols":7,"rows_kept":3}
["\n"," Dim r As Range 'Variable useed for Each cell with a Line of Code ( or an empty cell )"," Dim rng As Range 'Variable used for Full 1 column ( Column A ) Range of Pasted in code. ( All Code lines Cells column A )"," Dim x() As String 'The VBA Strings collection Split function will be used to return a 1 Dimension \"psuedo horizontal\" Array of a the Line part split by a space,  \" \"   ,  ( so using \" \"  as delimiter )           http://www.mrexcel.com/forum/general-excel-discussion-other-questions/929381-visual-basic-applications-split-function-third-argument-refers-maximum-outputs-%93when-splitting-stops-%94.html               get back ( also from 2D 1 column )     https://msdn.microsoft.com/de-de/library/b65z3h4h(v=vs.90).aspx"," Dim i As Long 'vaiable for added line number"," Let i = 10 'the first Line number to be added set to 10"," Set rng = Range(\"A1:A\" & Cells(Rows.Count, 1).End(xlUp).Row & \"\") 'Determine last pasted in code line. Last used cell found by following:  Applying the .End() Property to the range Object of last cell in Column 1, which returns a new Range object, that of the last cell ( as looking here optionally \"XL Up\" from the last Cell). Further this new range objrct has the .Row property applied to return the Row Number"]
[" ",{"$f":"CODE(A2)","v":32}]
[null,{"$f":"CODE(\"hdgadg9\")","v":104}]

{"sheet":"Pupils Dashboard","index":4,"n_rows":23,"n_cols":274,"rows_kept":23}
[{"$nulls":261},"Excel 2016 (Windows) 32 bit"]
[{"$nulls":262},"JC","JD","JE","JF","JG","JH","JI","JJ","JK","JL","JM","JN"]
[{"$nulls":261},3,"Academic PE","Art","Biology","BTEC IT","Business Studies","Chemistry","Classical Civilisation","Drama","Design Technology","Economics","English Literature","English Language"]
[{"$nulls":261},4,5,null,5]
[{"$nulls":261},5,{"$nulls":9},5]
[{"$nulls":261},6]
[{"$nulls":261},7,{"$nulls":8},8]
[{"$nulls":261},8,null,null,7]
[{"$nulls":261},9,{"$nulls":9},7]
[{"$nulls":261},10,{"$nulls":6},4]
[{"$nulls":261},11,{"$nulls":4},5,5]
[{"$nulls":261},12,{"$nulls":4},4,{"$nulls":5},4]
[{"$nulls":261},13,{"$nulls":11},4]
[{"$nulls":261},14,5,{"$nulls":7},6]
[{"$nulls":261},15,7,null,6,null,null,7]
[{"$nulls":261},16,{"$nulls":8},5]
[{"$nulls":261},17,{"$nulls":4},6,{"$nulls":4},3]
[{"$nulls":261},18,null,null,7,{"$nulls":3},5]
[{"$nulls":261},19,{"$nulls":4},4,{"$nulls":4},4]
[{"$nulls":261},20,null,null,6,null,null,6,{"$nulls":3},6]
[{"$nulls":261},21,{"$nulls":10},7]
[]
[{"$nulls":261},"https://www.excelforum.com/excel-formulas-and-functions/1176104-extracting-bottom-3-values-from-a-list-selected-from-a-drop-down-list.html"]