{"text_format":"1","workbook":"xlsx","n_sheets":53,"sheets":["Home Page","Serial Number","Insert Multiple Columns","Delete Columns","Insert Multiple Rows","Delete Rows","Delete Blank Rows","Merge Unmerge","Sorting Data","Filtering Data","Unique Values","Min Value","Max Value","Top 5","Duplicate Values","Greater than Values","Lower than Values","Alternate Rows","Cells with Comments","Except Active","Unhide Hidden Sheet","Insert Multiple Sheets","Sort Worksheets","Save as Single pdf","Delete Blank Sheet","Unhide Row & Column","Copy Sheet to New Workbook","Active Workbook in Email","Close Workbook","FormulatoValue","Upper Case","Lower Case","Proper Case","Remove Char from Selection","Remove Decimals","Split Text","Join Text","Sqaure Root","Cubic Root","Odd Even","Add Hyperlinks","Remove Hyperlinks","Range into Image","Blank to Zero","Highlight Blank","Negative Sign","Insert Time & Date","Remove Time","Remove Date","Range To Array","CSV to XLSX","Advanced Filter","Extract Comments"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home Page","index":0,"n_rows":67,"n_cols":3,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Macros in Excel VBA Examples"]
[null,"Let's jump into the fascinating world of Excel macros. Read the provided article covering the essential basics with 50++ examples to get started. Practice the examples in this section to get in-depth experience with VBA Macros."]
[]
[null,"Prepared By","Yousuf Khan"]
[null,"Reviewed By","Seemanto Saha"]
[null,"Last Update","2023-12-06"]
[null,"Article Link","Learn Excel Macros & VBA Programming"]
[]
[null,"Examples"]
[null,"1. Enter Serial Numbers"]
[null,"2. Insert Multiple Columns"]
[null,"3. Delete Columns"]
[null,"4. Insert Multiple Rows"]
[null,"5. Delete Rows"]
[null,"6. Delete Blank Rows"]
[null,"7. Merge/Unmerge Cells"]
[null,"8. Sort Data in Ascending Order"]
[null,"9. Filter Data Based on Cell Value"]
[null,"10. Find Unique Values"]
[null,"11. Get Min Value in the Range"]
[null,"12. Highlight Max Value in the Range"]
[null,"13. Get Top 5 Values"]
[null,"14. Highlight Duplicates from Selection"]
[null,"15. Highlight Greater than Values"]
[null,"16. Highlight Lower Than Values"]
[null,"17. Highlight Alternate Rows in a Range"]
[null,"18. Find All Cells With Comments"]
[null,"19. Hide all but the Active Worksheet"]
[null,"20. Unhide all Hidden Worksheets"]
[null,"21. Insert Multiple Worksheets"]
[null,"22. Sort Worksheets in Alphabetical Order"]
[null,"23. Save Each Worksheet as a Single PDF"]
[null,"24. Delete all Blank Worksheets"]
[null,"25. Unhide all Rows and Columns"]
[null,"26. Copy Active Worksheet into a New Workbook"]
[null,"27. Send Active Workbook in an Email"]
[null,"28. Close a Workbook with/without Saving"]
[null,"29. Convert all Formulas into Values"]
[null,"30. Convert to Upper Case"]
[null,"31. Convert to Lower Case"]
[null,"32. Convert to Proper Case"]
[null,"33. Remove a Character from Selection"]
[null,"34. Remove Decimals from Numbers"]
[null,"35. Split Text from a Range"]
[null,"36. Join Texts from a Range"]
[null,"37. Calculate Square Root"]
[null,"38. Calculate Cubic Root"]
[null,"39. Check Even or Odd"]
[null,"40. Add Hyperlinks"]
[null,"41. Remove Hyperlinks"]
[null,"42. Convert Range into an Image"]
[null,"43. Replace Blank Cells with Zeros"]
[null,"44. Highlight Blank Cells With VBA"]
[null,"45. Remove Negative Signs"]
[null,"46. Insert Date and Time"]
[null,"47. Remove Time from Time & Date"]
[null,"48. Remove Date from Time & Date"]
[null,"49. Convert Range to Array"]
[null,"50. Convert CSV to Excel"]
[null,"51. Advanced Filter to Range"]
[null,"52. Extract Comments from Cells"]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Serial Number","index":1,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50+ Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,null,"Top 50+ Useful Examples of Macros in Excel VBA"]
[]
[null,"Entering Serial Number",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Serial No.","Full Name","April","May",null,null,null,null,null,"Serial No.","Full Name","April","May"]
[null,1,"Marilyn Pittman",814,1938,null,null,null,null,null,null,"Marilyn Pittman",814,1938]
[null,2,"Samantha Carson",1923,914,null,null,null,null,null,null,"Samantha Carson",1923,914]
[null,3,"Clinton Webster",737,1012,null,null,null,null,null,null,"Clinton Webster",737,1012]
[null,4,"Chester Paul",1032,593,null,null,null,null,null,null,"Chester Paul",1032,593]
[null,5,"Rodney Gomez",1885,669,null,null,null,null,null,null,"Rodney Gomez",1885,669]
[null,6,"Jaime Schultz",562,708,null,null,null,null,null,null,"Jaime Schultz",562,708]
[null,7,"Abel Alvarado",547,548,null,null,null,null,null,null,"Abel Alvarado",547,548]
[null,8,"Rudy Palmer",953,843,null,null,null,null,null,null,"Rudy Palmer",953,843]
[null,9,"Ryan Russell",831,856,null,null,null,null,null,null,"Ryan Russell",831,856]
[null,10,"Ramiro Harper",1671,1145,null,null,null,null,null,null,"Ramiro Harper",1671,1145]
[null,11,"Maggie Gilbert",1795,1955,null,null,null,null,null,null,"Maggie Gilbert",1795,1955]
[null,12,"Jackie Berry",865,1656,null,null,null,null,null,null,"Jackie Berry",865,1656]
[null,13,"Franklin Sanders",1930,2000,null,null,null,null,null,null,"Franklin Sanders",1930,2000]
[null,14,"Pablo Beck",1749,1006,null,null,null,null,null,null,"Pablo Beck",1749,1006]
[null,15,"Jeffrey Casey",1910,1139,null,null,null,null,null,null,"Jeffrey Casey",1910,1139]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Insert Multiple Columns","index":2,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50+ Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,null,"Top 50+ Useful Examples of Macros in Excel VBA"]
[]
[null,"Inserting Multiple Columns",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Serial No.","Full Name",null,"April","May",null,null,null,null,"Serial No.","Full Name","April","May"]
[null,1,"Marilyn Pittman",null,814,1938,null,null,null,null,1,"Marilyn Pittman",814,1938]
[null,2,"Samantha Carson",null,1923,914,null,null,null,null,2,"Samantha Carson",1923,914]
[null,3,"Clinton Webster",null,737,1012,null,null,null,null,3,"Clinton Webster",737,1012]
[null,4,"Chester Paul",null,1032,593,null,null,null,null,4,"Chester Paul",1032,593]
[null,5,"Rodney Gomez",null,1885,669,null,null,null,null,5,"Rodney Gomez",1885,669]
[null,6,"Jaime Schultz",null,562,708,null,null,null,null,6,"Jaime Schultz",562,708]
[null,7,"Abel Alvarado",null,547,548,null,null,null,null,7,"Abel Alvarado",547,548]
[null,8,"Rudy Palmer",null,953,843,null,null,null,null,8,"Rudy Palmer",953,843]
[null,9,"Ryan Russell",null,831,856,null,null,null,null,9,"Ryan Russell",831,856]
[null,10,"Ramiro Harper",null,1671,1145,null,null,null,null,10,"Ramiro Harper",1671,1145]
[null,11,"Maggie Gilbert",null,1795,1955,null,null,null,null,11,"Maggie Gilbert",1795,1955]
[null,12,"Jackie Berry",null,865,1656,null,null,null,null,12,"Jackie Berry",865,1656]
[null,13,"Franklin Sanders",null,1930,2000,null,null,null,null,13,"Franklin Sanders",1930,2000]
[null,14,"Pablo Beck",null,1749,1006,null,null,null,null,14,"Pablo Beck",1749,1006]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Delete Columns","index":3,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50+ Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Deleting Entire Columns",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Serial No.","Full Name","April","May",null,null,null,null,"Serial No.","Full Name","April","May"]
[null,1,"Marilyn Pittman",814,1938,null,null,null,null,1,"Marilyn Pittman",814,1938]
[null,2,"Samantha Carson",1923,914,null,null,null,null,2,"Samantha Carson",1923,914]
[null,3,"Clinton Webster",737,1012,null,null,null,null,3,"Clinton Webster",737,1012]
[null,4,"Chester Paul",1032,593,null,null,null,null,4,"Chester Paul",1032,593]
[null,5,"Rodney Gomez",1885,669,null,null,null,null,5,"Rodney Gomez",1885,669]
[null,6,"Jaime Schultz",562,708,null,null,null,null,6,"Jaime Schultz",562,708]
[null,7,"Abel Alvarado",547,548,null,null,null,null,7,"Abel Alvarado",547,548]
[null,8,"Rudy Palmer",953,843,null,null,null,null,8,"Rudy Palmer",953,843]
[null,9,"Ryan Russell",831,856,null,null,null,null,9,"Ryan Russell",831,856]
[null,10,"Ramiro Harper",1671,1145,null,null,null,null,10,"Ramiro Harper",1671,1145]
[null,11,"Maggie Gilbert",1795,1955,null,null,null,null,11,"Maggie Gilbert",1795,1955]
[null,12,"Jackie Berry",865,1656,null,null,null,null,12,"Jackie Berry",865,1656]
[null,13,"Franklin Sanders",1930,2000,null,null,null,null,13,"Franklin Sanders",1930,2000]
[null,14,"Pablo Beck",1749,1006,null,null,null,null,14,"Pablo Beck",1749,1006]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Insert Multiple Rows","index":4,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Inserting Multiple Rows",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Serial No.","Full Name","April","May",null,null,null,null,null,"Serial No.","Full Name","April","May"]
[null,1,"Marilyn Pittman",814,1938,null,null,null,null,null,1,"Marilyn Pittman",814,1938]
[null,2,"Samantha Carson",1923,914,null,null,null,null,null,2,"Samantha Carson",1923,914]
[null,3,"Clinton Webster",737,1012,null,null,null,null,null,3,"Clinton Webster",737,1012]
[null,4,"Chester Paul",1032,593,null,null,null,null,null,4,"Chester Paul",1032,593]
[null,5,"Rodney Gomez",1885,669,null,null,null,null,null,5,"Rodney Gomez",1885,669]
[]
[null,6,"Jaime Schultz",562,708,null,null,null,null,null,6,"Jaime Schultz",562,708]
[null,7,"Abel Alvarado",547,548,null,null,null,null,null,7,"Abel Alvarado",547,548]
[null,8,"Rudy Palmer",953,843,null,null,null,null,null,8,"Rudy Palmer",953,843]
[null,9,"Ryan Russell",831,856,null,null,null,null,null,9,"Ryan Russell",831,856]
[null,10,"Ramiro Harper",1671,1145,null,null,null,null,null,10,"Ramiro Harper",1671,1145]
[null,11,"Maggie Gilbert",1795,1955,null,null,null,null,null,11,"Maggie Gilbert",1795,1955]
[null,12,"Jackie Berry",865,1656,null,null,null,null,null,12,"Jackie Berry",865,1656]
[null,13,"Franklin Sanders",1930,2000,null,null,null,null,null,13,"Franklin Sanders",1930,2000]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Delete Rows","index":5,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Deleting Entire Row",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Serial No.","Full Name","April","May",null,null,null,null,"Serial No.","Full Name","April","May"]
[null,1,"Marilyn Pittman",814,1938,null,null,null,null,1,"Marilyn Pittman",814,1938]
[null,2,"Samantha Carson",1923,914,null,null,null,null,2,"Samantha Carson",1923,914]
[null,3,"Clinton Webster",737,1012,null,null,null,null,3,"Clinton Webster",737,1012]
[null,4,"Chester Paul",1032,593,null,null,null,null,4,"Chester Paul",1032,593]
[null,5,"Rodney Gomez",1885,669,null,null,null,null,5,"Rodney Gomez",1885,669]
[null,6,"Jaime Schultz",562,708,null,null,null,null,6,"Jaime Schultz",562,708]
[null,7,"Abel Alvarado",547,548,null,null,null,null,7,"Abel Alvarado",547,548]
[null,8,"Rudy Palmer",953,843,null,null,null,null,8,"Rudy Palmer",953,843]
[null,9,"Ryan Russell",831,856,null,null,null,null,9,"Ryan Russell",831,856]
[null,10,"Ramiro Harper",1671,1145,null,null,null,null,10,"Ramiro Harper",1671,1145]
[null,11,"Maggie Gilbert",1795,1955,null,null,null,null,11,"Maggie Gilbert",1795,1955]
[null,12,"Jackie Berry",865,1656,null,null,null,null,12,"Jackie Berry",865,1656]
[null,13,"Franklin Sanders",1930,2000,null,null,null,null,13,"Franklin Sanders",1930,2000]
[]
[null,"Back to Home Page"]

{"sheet":"Delete Blank Rows","index":6,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Deleting Blank Rows",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Serial No.","Full Name","April","May",null,null,null,null,"Serial No.","Full Name","April","May"]
[null,1,"Marilyn Pittman",814,1938,null,null,null,null,1,"Marilyn Pittman",814,1938]
[null,2,"Samantha Carson",1923,914,null,null,null,null,2,"Samantha Carson",1923,914]
[null,3,"Clinton Webster",737,1012,null,null,null,null,3,"Clinton Webster",737,1012]
[null,4,"Chester Paul",1032,593,null,null,null,null,4,"Chester Paul",1032,593]
[null,5,"Rodney Gomez",1885,669,null,null,null,null,5,"Rodney Gomez",1885,669]
[]
[null,6,"Jaime Schultz",562,708,null,null,null,null,6,"Jaime Schultz",562,708]
[null,7,"Abel Alvarado",547,548,null,null,null,null,7,"Abel Alvarado",547,548]
[null,8,"Rudy Palmer",953,843,null,null,null,null,8,"Rudy Palmer",953,843]
[null,9,"Ryan Russell",831,856,null,null,null,null,9,"Ryan Russell",831,856]
[null,10,"Ramiro Harper",1671,1145,null,null,null,null,10,"Ramiro Harper",1671,1145]
[null,11,"Maggie Gilbert",1795,1955,null,null,null,null,11,"Maggie Gilbert",1795,1955]
[null,12,"Jackie Berry",865,1656,null,null,null,null,12,"Jackie Berry",865,1656]
[null,13,"Franklin Sanders",1930,2000,null,null,null,null,13,"Franklin Sanders",1930,2000]
[]
[null,"Back to Home Page"]

{"sheet":"Merge Unmerge","index":7,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,1,7,1]]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Merging Unmerging Cells",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Source City","Latitude","Longitude","Destination City",null,null,null,null,null,"Source City","Latitude","Longitude","Destination City"]
[null,"New York",40.712800000000001,-74.006,"Los Angeles",null,null,null,null,null,"New York",40.712800000000001,-74.006,"Los Angeles"]
[null,null,37.774900000000002,-122.4194,"Seattle",null,null,null,null,null,"New York",37.774900000000002,-122.4194,"Seattle"]
[null,null,41.878100000000003,-87.629800000000003,"Miami",null,null,null,null,null,"New York",41.878100000000003,-87.629800000000003,"Miami"]
[null,"Boston",42.360100000000003,-71.058899999999994,"Washington D.C.",null,null,null,null,null,"Boston",42.360100000000003,-71.058899999999994,"Washington D.C."]
[null,"Boston",29.760400000000001,-95.369799999999998,"Denver",null,null,null,null,null,"Boston",29.760400000000001,-95.369799999999998,"Denver"]
[null,"Boston",36.169899999999998,-115.13979999999999,"Grand Canyon",null,null,null,null,null,"Boston",36.169899999999998,-115.13979999999999,"Grand Canyon"]
[null,"Atlanta",33.749000000000002,-84.388000000000005,"Nashville",null,null,null,null,null,"Atlanta",33.749000000000002,-84.388000000000005,"Nashville"]
[null,"Atlanta",32.776699999999998,-96.796999999999997,"New Orleans",null,null,null,null,null,"Atlanta",32.776699999999998,-96.796999999999997,"New Orleans"]
[null,"Atlanta",32.715699999999998,-117.1611,"Phoenix",null,null,null,null,null,"Atlanta",32.715699999999998,-117.1611,"Phoenix"]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Sorting Data","index":8,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,2,6],[2,10,2,15]]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Sorting Data in Ascending Order",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,null,null,null,null,"Total Marks",300,null,null,null,null,null,null,null,"Total Marks",300]
[]
[null,"ID","Name","Math","Physics","Chemistry","Percentage",null,null,null,"ID","Name","Math","Physics","Chemistry","Percentage"]
[null,1210034,"Steve Nguyen",45,54,40,{"$f":"SUM(D8:F8)/$G$5","v":0.46333333333333332},null,null,null,1210009,"Tracy Blumstein",80,74,43,{"$f":"SUM(M8:O8)/$G$5","v":0.65666666666666662}]
[null,1210046,"Gene Hale",60,51,56,0.55666666666666664,null,null,null,1210046,"Gene Hale",60,51,56,0.55666666666666664]
[null,1210041,"Alejandro Grove",80,56,41,0.59,null,null,null,1210034,"Steve Nguyen",45,54,40,0.46333333333333332]
[null,1210087,"Andrew Allen",56,45,76,0.59,null,null,null,1210043,"Harold Pawlan",50,87,50,0.62333333333333329]
[null,1210081,"Ken Black",80,59,42,0.60333333333333339,null,null,null,1210041,"Alejandro Grove",80,56,41,0.59]
[null,1210063,"Zuschuss Donatelli",60,56,66,0.60666666666666669,null,null,null,1210087,"Andrew Allen",56,45,76,0.59]
[null,1210031,"Emily Burns",59,69,57,0.6166666666666667,null,null,null,1210081,"Ken Black",80,59,42,0.60333333333333339]
[null,1210043,"Harold Pawlan",50,87,50,0.62333333333333329,null,null,null,1210031,"Emily Burns",59,69,57,0.6166666666666667]
[null,1210008,"Sandra Flanagan",70,77,42,0.63,null,null,null,1210008,"Sandra Flanagan",70,77,42,0.63]
[null,1210096,"Pete Kriz",61,69,65,0.65,null,null,null,1210096,"Pete Kriz",61,69,65,0.65]
[null,1210009,"Tracy Blumstein",80,74,43,0.65666666666666662,null,null,null,1210063,"Zuschuss Donatelli",60,56,66,0.60666666666666669]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Filtering Data","index":9,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,7,2,9]]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Filtering Data Based on Cell Value",null,null,null,null,null,"Practice Yourself"]
[]
[null,"ID","Name","Obtain Marks",null,null,null,"ID","Name","Obtain Marks"]
[null,1210009,"Tracy Blumstein",80,null,null,null,1210009,"Tracy Blumstein",80]
[null,1210046,"Gene Hale",60,null,null,null,1210046,"Gene Hale",60]
[null,1210034,"Steve Nguyen",45,null,null,null,1210034,"Steve Nguyen",45]
[null,1210043,"Harold Pawlan",50,null,null,null,1210043,"Harold Pawlan",50]
[null,1210041,"Alejandro Grove",80,null,null,null,1210041,"Alejandro Grove",80]
[null,1210087,"Andrew Allen",56,null,null,null,1210087,"Andrew Allen",56]
[null,1210081,"Ken Black",80,null,null,null,1210081,"Ken Black",80]
[null,1210031,"Emily Burns",59,null,null,null,1210031,"Emily Burns",59]
[null,1210008,"Sandra Flanagan",70,null,null,null,1210008,"Sandra Flanagan",70]
[null,1210096,"Pete Kriz",61,null,null,null,1210096,"Pete Kriz",61]
[null,1210063,"Zuschuss Donatelli",60,null,null,null,1210063,"Zuschuss Donatelli",60]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Unique Values","index":10,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Getting Unique Values",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Order Date","Customer Name","Ship Date",null,null,null,null,"Order No","Order Date","Customer Name","Ship Date"]
[null,"5071-1","2013-05-05","Christopher Schild","2013-05-07",null,null,null,null,"5071-1","2013-05-05","Christopher Schild","2013-05-07"]
[null,"5071-2","2013-05-05","Christopher Schild","2013-05-07",null,null,null,null,"5071-2","2013-05-05","Christopher Schild","2013-05-07"]
[null,"5145-1","2013-05-05","Cyma Kinney","2013-05-08",null,null,null,null,"5145-1","2013-05-05","Cyma Kinney","2013-05-08"]
[null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10",null,null,null,null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10"]
[null,"5160-1","2013-06-08","Berenike Kampe","2013-06-10",null,null,null,null,"5160-1","2013-06-08","Berenike Kampe","2013-06-10"]
[null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10",null,null,null,null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10"]
[null,"5168-1","2013-06-11","Christy Brittain","2013-06-10",null,null,null,null,"5168-1","2013-06-11","Christy Brittain","2013-06-10"]
[null,"5168-2","2013-07-15","Christy Brittain","2013-07-22",null,null,null,null,"5168-2","2013-07-15","Christy Brittain","2013-07-22"]
[null,"5195-1","2013-07-20","Alex Grayson","2013-07-22",null,null,null,null,"5195-1","2013-07-20","Alex Grayson","2013-07-22"]
[null,"5195-2","2013-07-21","Alex Grayson","2013-07-22",null,null,null,null,"5195-2","2013-07-21","Alex Grayson","2013-07-22"]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Min Value","index":11,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Finding Min Value",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,"5071-1",2.23,41,{"$f":"K6*L6","v":91.429999999999993}]
[null,"5071-2",6.68,2,{"$f":"C7*D7","v":13.36},null,null,null,null,"5071-2",6.68,2,{"$f":"K7*L7","v":13.36}]
[null,"5145-1",5.18,2,10.36,null,null,null,null,"5145-1",5.18,2,10.36]
[null,"5145-2",5.84,4,23.36,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",20.99,41,860.58999999999992,null,null,null,null,"5160-1",20.99,41,860.58999999999992]
[null,"5160-2",5.4,26,140.4,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",6.47,20,129.4,null,null,null,null,"5168-1",6.47,20,129.4]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Max Value","index":12,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Highlighting Max Value",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,null,"5071-1",2.23,41,{"$f":"L6*M6","v":91.429999999999993}]
[null,"5071-2",6.68,2,{"$f":"C7*D7","v":13.36},null,null,null,null,null,"5071-2",6.68,2,{"$f":"L7*M7","v":13.36}]
[null,"5145-1",5.18,2,10.36,null,null,null,null,null,"5145-1",5.18,2,10.36]
[null,"5145-2",5.84,4,23.36,null,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",20.99,41,860.58999999999992,null,null,null,null,null,"5160-1",20.99,41,860.58999999999992]
[null,"5160-2",5.4,26,140.4,null,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",6.47,20,129.4,null,null,null,null,null,"5168-1",6.47,20,129.4]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Top 5","index":13,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Finding Top 5 Values",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,"5071-1",2.23,41,{"$f":"K6*L6","v":91.429999999999993}]
[null,"5071-2",6.68,2,{"$f":"C7*D7","v":13.36},null,null,null,null,"5071-2",6.68,2,{"$f":"K7*L7","v":13.36}]
[null,"5145-1",5.18,2,10.36,null,null,null,null,"5145-1",5.18,2,10.36]
[null,"5145-2",5.84,4,23.36,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",20.99,41,860.58999999999992,null,null,null,null,"5160-1",20.99,41,860.58999999999992]
[null,"5160-2",5.4,26,140.4,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",6.47,20,129.4,null,null,null,null,"5168-1",6.47,20,129.4]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Duplicate Values","index":14,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Finding Duplicate Values",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,"5071-1",2.23,41,{"$f":"K6*L6","v":91.429999999999993}]
[null,"5071-2",6.68,2,{"$f":"C7*D7","v":13.36},null,null,null,null,"5071-2",6.68,2,{"$f":"K7*L7","v":13.36}]
[null,"5145-1",5.18,2,10.36,null,null,null,null,"5145-1",5.18,2,10.36]
[null,"5145-2",5.84,4,23.36,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",2.23,41,91.429999999999993,null,null,null,null,"5160-1",2.23,41,91.429999999999993]
[null,"5160-2",5.4,26,140.4,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",6.47,20,129.4,null,null,null,null,"5168-1",6.47,20,129.4]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Greater than Values","index":15,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Highlighting Greater than Values",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,"5071-1",2.23,41,{"$f":"K6*L6","v":91.429999999999993}]
[null,"5071-2",6.68,2,{"$f":"C7*D7","v":13.36},null,null,null,null,"5071-2",6.68,2,{"$f":"K7*L7","v":13.36}]
[null,"5145-1",5.18,2,10.36,null,null,null,null,"5145-1",5.18,2,10.36]
[null,"5145-2",5.84,4,23.36,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",2.23,41,91.429999999999993,null,null,null,null,"5160-1",2.23,41,91.429999999999993]
[null,"5160-2",5.4,26,140.4,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",6.47,20,129.4,null,null,null,null,"5168-1",6.47,20,129.4]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Lower than Values","index":16,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Getting Lower than Values",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,"5071-1",2.23,41,{"$f":"K6*L6","v":91.429999999999993}]
[null,"5071-2",6.68,2,{"$f":"C7*D7","v":13.36},null,null,null,null,"5071-2",6.68,2,{"$f":"K7*L7","v":13.36}]
[null,"5145-1",5.18,2,10.36,null,null,null,null,"5145-1",5.18,2,10.36]
[null,"5145-2",5.84,4,23.36,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",2.23,41,91.429999999999993,null,null,null,null,"5160-1",2.23,41,91.429999999999993]
[null,"5160-2",5.4,26,140.4,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",6.47,20,129.4,null,null,null,null,"5168-1",6.47,20,129.4]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Alternate Rows","index":17,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Highlight Alternate Rows in a Range",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Retail Price","Order Quantity",null,null,null,null,"Order No","Customer Name","Retail Price","Order Quantity"]
[null,"5071-1","Christopher Schild",2.23,41,null,null,null,null,"5071-1","Christopher Schild",2.23,41]
[null,"5071-2","Christopher Schild",6.68,2,null,null,null,null,"5071-2","Christopher Schild",6.68,2]
[null,"5145-1","Cyma Kinney",5.18,2,null,null,null,null,"5145-1","Cyma Kinney",5.18,2]
[null,"5145-2","Cyma Kinney",5.84,4,null,null,null,null,"5145-2","Cyma Kinney",5.84,4]
[null,"5160-1","Berenike Kampe",2.23,41,null,null,null,null,"5160-1","Berenike Kampe",2.23,41]
[null,"5160-2","Berenike Kampe",5.4,26,null,null,null,null,"5160-2","Berenike Kampe",5.4,26]
[null,"5168-1","Christy Brittain",6.47,20,null,null,null,null,"5168-1","Christy Brittain",6.47,20]
[null,"5168-2","Christy Brittain",2.84,39,null,null,null,null,"5168-2","Christy Brittain",2.84,39]
[null,"5195-1","Alex Grayson",2.88,11,null,null,null,null,"5195-1","Alex Grayson",2.88,11]
[null,"5195-2","Alex Grayson",19.98,43,null,null,null,null,"5195-2","Alex Grayson",19.98,43]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Cells with Comments","index":18,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Find All Cells with Comments",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,"5071-1",2.23,41,{"$f":"K6*L6","v":91.429999999999993}]
[null,"5071-2",6.68,2,13.36,null,null,null,null,"5071-2",6.68,2,13.36]
[null,"5145-1",5.18,2,10.36,null,null,null,null,"5145-1",5.18,2,10.36]
[null,"5145-2",5.84,4,23.36,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",2.23,41,91.429999999999993,null,null,null,null,"5160-1",2.23,41,91.429999999999993]
[null,"5160-2",5.4,26,140.4,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",1.5948728690385892,20,31.897457380771783,null,null,null,null,"5168-1",1.5948728690385892,20,31.897457380771783]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Except Active","index":19,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Hiding All Worksheets Except Active Sheet",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Retail Price","Order Quantity",null,null,null,null,"Order No","Customer Name","Retail Price","Order Quantity"]
[null,"5071-1","Christopher Schild",2.23,41,null,null,null,null,"5071-1","Christopher Schild",2.23,41]
[null,"5071-2","Christopher Schild",6.68,2,null,null,null,null,"5071-2","Christopher Schild",6.68,2]
[null,"5145-1","Cyma Kinney",5.18,2,null,null,null,null,"5145-1","Cyma Kinney",5.18,2]
[null,"5145-2","Cyma Kinney",5.84,4,null,null,null,null,"5145-2","Cyma Kinney",5.84,4]
[null,"5160-1","Berenike Kampe",2.23,41,null,null,null,null,"5160-1","Berenike Kampe",2.23,41]
[null,"5160-2","Berenike Kampe",5.4,26,null,null,null,null,"5160-2","Berenike Kampe",5.4,26]
[null,"5168-1","Christy Brittain",1.5948728690385892,20,null,null,null,null,"5168-1","Christy Brittain",6.47,20]
[null,"5168-2","Christy Brittain",2.84,39,null,null,null,null,"5168-2","Christy Brittain",2.84,39]
[null,"5195-1","Alex Grayson",2.88,11,null,null,null,null,"5195-1","Alex Grayson",2.88,11]
[null,"5195-2","Alex Grayson",19.98,43,null,null,null,null,"5195-2","Alex Grayson",19.98,43]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Unhide Hidden Sheet","index":20,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Unhiding All Hidden Worksheets",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Retail Price","Order Quantity",null,null,null,null,"Order No","Customer Name","Retail Price","Order Quantity"]
[null,"5071-1","Christopher Schild",2.23,41,null,null,null,null,"5071-1","Christopher Schild",2.23,41]
[null,"5071-2","Christopher Schild",6.68,2,null,null,null,null,"5071-2","Christopher Schild",6.68,2]
[null,"5145-1","Cyma Kinney",5.18,2,null,null,null,null,"5145-1","Cyma Kinney",5.18,2]
[null,"5145-2","Cyma Kinney",5.84,4,null,null,null,null,"5145-2","Cyma Kinney",5.84,4]
[null,"5160-1","Berenike Kampe",2.23,41,null,null,null,null,"5160-1","Berenike Kampe",2.23,41]
[null,"5160-2","Berenike Kampe",5.4,26,null,null,null,null,"5160-2","Berenike Kampe",5.4,26]
[null,"5168-1","Christy Brittain",1.5948728690385892,20,null,null,null,null,"5168-1","Christy Brittain",6.47,20]
[null,"5168-2","Christy Brittain",2.84,39,null,null,null,null,"5168-2","Christy Brittain",2.84,39]
[null,"5195-1","Alex Grayson",2.88,11,null,null,null,null,"5195-1","Alex Grayson",2.88,11]
[null,"5195-2","Alex Grayson",19.98,43,null,null,null,null,"5195-2","Alex Grayson",19.98,43]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Insert Multiple Sheets","index":21,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Inserting Multiple Worksheets",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Retail Price","Order Quantity",null,null,null,null,"Order No","Customer Name","Retail Price","Order Quantity"]
[null,"5071-1","Christopher Schild",2.23,41,null,null,null,null,"5071-1","Christopher Schild",2.23,41]
[null,"5071-2","Christopher Schild",6.68,2,null,null,null,null,"5071-2","Christopher Schild",6.68,2]
[null,"5145-1","Cyma Kinney",5.18,2,null,null,null,null,"5145-1","Cyma Kinney",5.18,2]
[null,"5145-2","Cyma Kinney",5.84,4,null,null,null,null,"5145-2","Cyma Kinney",5.84,4]
[null,"5160-1","Berenike Kampe",2.23,41,null,null,null,null,"5160-1","Berenike Kampe",2.23,41]
[null,"5160-2","Berenike Kampe",5.4,26,null,null,null,null,"5160-2","Berenike Kampe",5.4,26]
[null,"5168-1","Christy Brittain",1.5948728690385892,20,null,null,null,null,"5168-1","Christy Brittain",6.47,20]
[null,"5168-2","Christy Brittain",2.84,39,null,null,null,null,"5168-2","Christy Brittain",2.84,39]
[null,"5195-1","Alex Grayson",2.88,11,null,null,null,null,"5195-1","Alex Grayson",2.88,11]
[null,"5195-2","Alex Grayson",19.98,43,null,null,null,null,"5195-2","Alex Grayson",19.98,43]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Sort Worksheets","index":22,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Sorting Worksheets in Alphabetical Order",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Retail Price","Order Quantity",null,null,null,null,"Order No","Customer Name","Retail Price","Order Quantity"]
[null,"5071-1","Christopher Schild",2.23,41,null,null,null,null,"5071-1","Christopher Schild",2.23,41]
[null,"5071-2","Christopher Schild",6.68,2,null,null,null,null,"5071-2","Christopher Schild",6.68,2]
[null,"5145-1","Cyma Kinney",5.18,2,null,null,null,null,"5145-1","Cyma Kinney",5.18,2]
[null,"5145-2","Cyma Kinney",5.84,4,null,null,null,null,"5145-2","Cyma Kinney",5.84,4]
[null,"5160-1","Berenike Kampe",2.23,41,null,null,null,null,"5160-1","Berenike Kampe",2.23,41]
[null,"5160-2","Berenike Kampe",5.4,26,null,null,null,null,"5160-2","Berenike Kampe",5.4,26]
[null,"5168-1","Christy Brittain",1.5948728690385892,20,null,null,null,null,"5168-1","Christy Brittain",6.47,20]
[null,"5168-2","Christy Brittain",2.84,39,null,null,null,null,"5168-2","Christy Brittain",2.84,39]
[null,"5195-1","Alex Grayson",2.88,11,null,null,null,null,"5195-1","Alex Grayson",2.88,11]
[null,"5195-2","Alex Grayson",19.98,43,null,null,null,null,"5195-2","Alex Grayson",19.98,43]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Save as Single pdf","index":23,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Saving Each Worksheets as a Single PDF",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Retail Price","Order Quantity",null,null,null,null,"Order No","Customer Name","Retail Price","Order Quantity"]
[null,"5071-1","Christopher Schild",2.23,41,null,null,null,null,"5071-1","Christopher Schild",2.23,41]
[null,"5071-2","Christopher Schild",6.68,2,null,null,null,null,"5071-2","Christopher Schild",6.68,2]
[null,"5145-1","Cyma Kinney",5.18,2,null,null,null,null,"5145-1","Cyma Kinney",5.18,2]
[null,"5145-2","Cyma Kinney",5.84,4,null,null,null,null,"5145-2","Cyma Kinney",5.84,4]
[null,"5160-1","Berenike Kampe",2.23,41,null,null,null,null,"5160-1","Berenike Kampe",2.23,41]
[null,"5160-2","Berenike Kampe",5.4,26,null,null,null,null,"5160-2","Berenike Kampe",5.4,26]
[null,"5168-1","Christy Brittain",1.5948728690385892,20,null,null,null,null,"5168-1","Christy Brittain",6.47,20]
[null,"5168-2","Christy Brittain",2.84,39,null,null,null,null,"5168-2","Christy Brittain",2.84,39]
[null,"5195-1","Alex Grayson",2.88,11,null,null,null,null,"5195-1","Alex Grayson",2.88,11]
[null,"5195-2","Alex Grayson",19.98,43,null,null,null,null,"5195-2","Alex Grayson",19.98,43]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Delete Blank Sheet","index":24,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Unhide Row & Column","index":25,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Unhiding All Rows and Columns",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Retail Price","Order Quantity",null,null,null,null,"Order No","Customer Name","Retail Price","Order Quantity"]
[null,"5071-1","Christopher Schild",2.23,41,null,null,null,null,"5071-1","Christopher Schild",2.23,41]
[null,"5071-2","Christopher Schild",6.68,2,null,null,null,null,"5071-2","Christopher Schild",6.68,2]
[null,"5145-1","Cyma Kinney",5.18,2,null,null,null,null,"5145-1","Cyma Kinney",5.18,2]
[null,"5145-2","Cyma Kinney",5.84,4,null,null,null,null,"5145-2","Cyma Kinney",5.84,4]
[null,"5160-1","Berenike Kampe",2.23,41,null,null,null,null,"5160-1","Berenike Kampe",2.23,41]
[null,"5160-2","Berenike Kampe",5.4,26,null,null,null,null,"5160-2","Berenike Kampe",5.4,26]
[null,"5168-1","Christy Brittain",1.5948728690385892,20,null,null,null,null,"5168-1","Christy Brittain",6.47,20]
[null,"5168-2","Christy Brittain",2.84,39,null,null,null,null,"5168-2","Christy Brittain",2.84,39]
[null,"5195-1","Alex Grayson",2.88,11,null,null,null,null,"5195-1","Alex Grayson",2.88,11]
[null,"5195-2","Alex Grayson",19.98,43,null,null,null,null,"5195-2","Alex Grayson",19.98,43]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Copy Sheet to New Workbook","index":26,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Copying Active Worksheet into New Workbook",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Retail Price","Order Quantity",null,null,null,null,"Order No","Customer Name","Retail Price","Order Quantity"]
[null,"5071-1","Christopher Schild",2.23,41,null,null,null,null,"5071-1","Christopher Schild",2.23,41]
[null,"5071-2","Christopher Schild",6.68,2,null,null,null,null,"5071-2","Christopher Schild",6.68,2]
[null,"5145-1","Cyma Kinney",5.18,2,null,null,null,null,"5145-1","Cyma Kinney",5.18,2]
[null,"5145-2","Cyma Kinney",5.84,4,null,null,null,null,"5145-2","Cyma Kinney",5.84,4]
[null,"5160-1","Berenike Kampe",2.23,41,null,null,null,null,"5160-1","Berenike Kampe",2.23,41]
[null,"5160-2","Berenike Kampe",5.4,26,null,null,null,null,"5160-2","Berenike Kampe",5.4,26]
[null,"5168-1","Christy Brittain",1.5948728690385892,20,null,null,null,null,"5168-1","Christy Brittain",6.47,20]
[null,"5168-2","Christy Brittain",2.84,39,null,null,null,null,"5168-2","Christy Brittain",2.84,39]
[null,"5195-1","Alex Grayson",2.88,11,null,null,null,null,"5195-1","Alex Grayson",2.88,11]
[null,"5195-2","Alex Grayson",19.98,43,null,null,null,null,"5195-2","Alex Grayson",19.98,43]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Active Workbook in Email","index":27,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Sending Active Workbook in an Email",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Retail Price","Order Quantity",null,null,null,null,"Order No","Customer Name","Retail Price","Order Quantity"]
[null,"5071-1","Christopher Schild",2.23,41,null,null,null,null,"5071-1","Christopher Schild",2.23,41]
[null,"5071-2","Christopher Schild",6.68,2,null,null,null,null,"5071-2","Christopher Schild",6.68,2]
[null,"5145-1","Cyma Kinney",5.18,2,null,null,null,null,"5145-1","Cyma Kinney",5.18,2]
[null,"5145-2","Cyma Kinney",5.84,4,null,null,null,null,"5145-2","Cyma Kinney",5.84,4]
[null,"5160-1","Berenike Kampe",2.23,41,null,null,null,null,"5160-1","Berenike Kampe",2.23,41]
[null,"5160-2","Berenike Kampe",5.4,26,null,null,null,null,"5160-2","Berenike Kampe",5.4,26]
[null,"5168-1","Christy Brittain",1.5948728690385892,20,null,null,null,null,"5168-1","Christy Brittain",6.47,20]
[null,"5168-2","Christy Brittain",2.84,39,null,null,null,null,"5168-2","Christy Brittain",2.84,39]
[null,"5195-1","Alex Grayson",2.88,11,null,null,null,null,"5195-1","Alex Grayson",2.88,11]
[null,"5195-2","Alex Grayson",19.98,43,null,null,null,null,"5195-2","Alex Grayson",19.98,43]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Close Workbook","index":28,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Closing Workbooks with/without Saving",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Retail Price","Order Quantity",null,null,null,null,"Order No","Customer Name","Retail Price","Order Quantity"]
[null,"5071-1","Christopher Schild",2.23,41,null,null,null,null,"5071-1","Christopher Schild",2.23,41]
[null,"5071-2","Christopher Schild",6.68,2,null,null,null,null,"5071-2","Christopher Schild",6.68,2]
[null,"5145-1","Cyma Kinney",5.18,2,null,null,null,null,"5145-1","Cyma Kinney",5.18,2]
[null,"5145-2","Cyma Kinney",5.84,4,null,null,null,null,"5145-2","Cyma Kinney",5.84,4]
[null,"5160-1","Berenike Kampe",2.23,41,null,null,null,null,"5160-1","Berenike Kampe",2.23,41]
[null,"5160-2","Berenike Kampe",5.4,26,null,null,null,null,"5160-2","Berenike Kampe",5.4,26]
[null,"5168-1","Christy Brittain",1.5948728690385892,20,null,null,null,null,"5168-1","Christy Brittain",6.47,20]
[null,"5168-2","Christy Brittain",2.84,39,null,null,null,null,"5168-2","Christy Brittain",2.84,39]
[null,"5195-1","Alex Grayson",2.88,11,null,null,null,null,"5195-1","Alex Grayson",2.88,11]
[null,"5195-2","Alex Grayson",19.98,43,null,null,null,null,"5195-2","Alex Grayson",19.98,43]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"FormulatoValue","index":29,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Converting Formulas into Values",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2.23,41,91.429999999999993,null,null,null,"5071-1",2.23,41,{"$f":"J6*K6","v":91.429999999999993}]
[null,"5071-2",6.68,2,13.36,null,null,null,"5071-2",6.68,2,{"$f":"J7*K7","v":13.36}]
[null,"5145-1",5.18,2,10.36,null,null,null,"5145-1",5.18,2,10.36]
[null,"5145-2",5.84,4,23.36,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",2.23,41,91.429999999999993,null,null,null,"5160-1",2.23,41,91.429999999999993]
[null,"5160-2",5.4,26,140.4,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",1.5948728690385892,20,31.897457380771783,null,null,null,"5168-1",1.5948728690385892,20,31.897457380771783]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Upper Case","index":30,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Converting Text to Upper Case",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Order Date","CUSTOMER NAME",null,null,null,"Order No","Order Date","Customer Name"]
[null,"5071-1","2013-05-05","CHRISTOPHER SCHILD",null,null,null,"5071-1","2013-05-05","Christopher Schild"]
[null,"5071-2","2013-05-05","CHRISTOPHER SCHILD",null,null,null,"5071-2","2013-05-05","Christopher Schild"]
[null,"5145-1","1900-07-21T11:13:06.999","CYMA KINNEY",null,null,null,"5145-1","2013-05-05","Cyma Kinney"]
[null,"5145-2","2013-05-29","CYMA KINNEY",null,null,null,"5145-2","2013-05-29","Cyma Kinney"]
[null,"5160-1","1900-07-21T13:13:24.362","BERENIKE KAMPE",null,null,null,"5160-1","2013-06-08","Berenike Kampe"]
[null,"5160-2","2013-06-10","BERENIKE KAMPE",null,null,null,"5160-2","2013-06-10","Berenike Kampe"]
[null,"5168-1","1900-07-21T13:24:01.046","CHRISTY BRITTAIN",null,null,null,"5168-1","2013-06-11","Christy Brittain"]
[null,"5168-2","2013-07-15","CHRISTY BRITTAIN",null,null,null,"5168-2","2013-07-15","Christy Brittain"]
[null,"5195-1","2013-07-20","ALEX GRAYSON",null,null,null,"5195-1","2013-07-20","Alex Grayson"]
[null,"5195-2","2013-07-21","ALEX GRAYSON",null,null,null,"5195-2","2013-07-21","Alex Grayson"]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Lower Case","index":31,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Converting Text to Lower Case",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Order Date","customer name",null,null,null,"Order No","Order Date","Customer Name"]
[null,"5071-1","2013-05-05","christopher schild",null,null,null,"5071-1","2013-05-05","Christopher Schild"]
[null,"5071-2","2013-05-05","christopher schild",null,null,null,"5071-2","2013-05-05","Christopher Schild"]
[null,"5145-1","1900-07-21T11:13:06.999","cyma kinney",null,null,null,"5145-1","2013-05-05","Cyma Kinney"]
[null,"5145-2","2013-05-29","cyma kinney",null,null,null,"5145-2","2013-05-29","Cyma Kinney"]
[null,"5160-1","1900-07-21T13:13:24.362","berenike kampe",null,null,null,"5160-1","2013-06-08","Berenike Kampe"]
[null,"5160-2","2013-06-10","berenike kampe",null,null,null,"5160-2","2013-06-10","Berenike Kampe"]
[null,"5168-1","1900-07-21T13:24:01.046","christy brittain",null,null,null,"5168-1","2013-06-11","Christy Brittain"]
[null,"5168-2","2013-07-15","christy brittain",null,null,null,"5168-2","2013-07-15","Christy Brittain"]
[null,"5195-1","2013-07-20","alex grayson",null,null,null,"5195-1","2013-07-20","Alex Grayson"]
[null,"5195-2","2013-07-21","alex grayson",null,null,null,"5195-2","2013-07-21","Alex Grayson"]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Proper Case","index":32,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Converting Text to Proper Case",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Order Date","Customer Name",null,null,null,"Order No","Order Date","Customer Name"]
[null,"5071-1","2013-05-05","Christopher Schild",null,null,null,"5071-1","2013-05-05","christopher schild"]
[null,"5071-2","2013-05-05","Christopher Schild",null,null,null,"5071-2","2013-05-05","christopher schild"]
[null,"5145-1","1900-07-21T11:13:06.999","Cyma Kinney",null,null,null,"5145-1","2013-05-05","cyma kinney"]
[null,"5145-2","2013-05-29","Cyma Kinney",null,null,null,"5145-2","2013-05-29","cyma kinney"]
[null,"5160-1","1900-07-21T13:13:24.362","Berenike Kampe",null,null,null,"5160-1","2013-06-08","berenike kampe"]
[null,"5160-2","2013-06-10","Berenike Kampe",null,null,null,"5160-2","2013-06-10","berenike kampe"]
[null,"5168-1","1900-07-21T13:24:01.046","Christy Brittain",null,null,null,"5168-1","2013-06-11","christy brittain"]
[null,"5168-2","2013-07-15","Christy Brittain",null,null,null,"5168-2","2013-07-15","christy brittain"]
[null,"5195-1","2013-07-20","Alex Grayson",null,null,null,"5195-1","2013-07-20","alex grayson"]
[null,"5195-2","2013-07-21","Alex Grayson",null,null,null,"5195-2","2013-07-21","alex grayson"]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Remove Char from Selection","index":33,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Removing a Character from Selection",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Order Date","Customer Name",null,null,null,"Order No","Order Date","Customer Name"]
[null,"5071-1","2013-05-05","Christopher Schild",null,null,null,"5071-1","2013-05-05","Christopher Schild"]
[null,"5071-2","2013-05-05","Christopher Schild",null,null,null,"5071-2","2013-05-05","Christopher Schild"]
[null,"5145-1","1900-07-21T11:13:06.999","Cyma ",null,null,null,"5145-1","1900-07-21T11:13:06.999","Cyma "]
[null,"5145-2","2013-05-29","Cyma ",null,null,null,"5145-2","2013-05-29","Cyma "]
[null,"5160-1","1900-07-21T13:13:24.362","Berenike Kampe",null,null,null,"5160-1","1900-07-21T13:13:24.362","Berenike Kampe"]
[null,"5160-2","2013-06-10","Berenike Kampe",null,null,null,"5160-2","2013-06-10","Berenike Kampe"]
[null,"5168-1","1900-07-21T13:24:01.046","Christy Brittain",null,null,null,"5168-1","1900-07-21T13:24:01.046","Christy Brittain"]
[null,"5168-2","2013-07-15","Christy Brittain",null,null,null,"5168-2","2013-07-15","Christy Brittain"]
[null,"5195-1","2013-07-20","Alex Grayson",null,null,null,"5195-1","2013-07-20","Alex Grayson"]
[null,"5195-2","2013-07-21","Alex Grayson",null,null,null,"5195-2","2013-07-21","Alex Grayson"]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Remove Decimals","index":34,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Removing Decimals from Numbers",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Retail Price","Order Quantity",null,null,null,null,"Order No","Customer Name","Retail Price","Order Quantity"]
[null,"5071-1","Christopher Schild",2,41,null,null,null,null,"5071-1","Christopher Schild",2.23,41]
[null,"5071-2","Christopher Schild",6,2,null,null,null,null,"5071-2","Christopher Schild",6.68,2]
[null,"5145-1","Cyma Kinney",5,2,null,null,null,null,"5145-1","Cyma Kinney",5.18,2]
[null,"5145-2","Cyma Kinney",5,4,null,null,null,null,"5145-2","Cyma Kinney",5.84,4]
[null,"5160-1","Berenike Kampe",2,41,null,null,null,null,"5160-1","Berenike Kampe",2.23,41]
[null,"5160-2","Berenike Kampe",5,26,null,null,null,null,"5160-2","Berenike Kampe",5.4,26]
[null,"5168-1","Christy Brittain",6,20,null,null,null,null,"5168-1","Christy Brittain",6.47,20]
[null,"5168-2","Christy Brittain",2,39,null,null,null,null,"5168-2","Christy Brittain",2.84,39]
[null,"5195-1","Alex Grayson",2,11,null,null,null,null,"5195-1","Alex Grayson",2.88,11]
[null,"5195-2","Alex Grayson",19,43,null,null,null,null,"5195-2","Alex Grayson",19.98,43]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Split Text","index":35,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Spliting Text from a Range",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Full Name","First Name","Last Name",null,null,null,null,null,"Name","First Name","Last Name"]
[null,"Marilyn Pittman","Marilyn","Pittman",null,null,null,null,null,"Marilyn Pittman"]
[null,"Samantha Carson","Samantha","Carson",null,null,null,null,null,"Samantha Carson"]
[null,"Clinton Webster","Clinton","Webster",null,null,null,null,null,"Clinton Webster"]
[null,"Chester Paul","Chester","Paul",null,null,null,null,null,"Chester Paul"]
[null,"Rodney Gomez","Rodney","Gomez",null,null,null,null,null,"Rodney Gomez"]
[null,"Jaime Schultz","Jaime","Schultz",null,null,null,null,null,"Jaime Schultz"]
[null,"Abel Alvarado","Abel","Alvarado",null,null,null,null,null,"Abel Alvarado"]
[null,"Rudy Palmer","Rudy","Palmer",null,null,null,null,null,"Rudy Palmer"]
[null,"Ryan Russell","Ryan","Russell",null,null,null,null,null,"Ryan Russell"]
[null,"Ramiro Harper","Ramiro","Harper",null,null,null,null,null,"Ramiro Harper"]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Join Text","index":36,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Joining Text from a Range",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,"First Name","Last Name","Full Name"]
[null,"Marilyn","Pittman","Marilyn Pittman",null,null,null,null,"Marilyn","Pittman"]
[null,"Samantha","Carson","Samantha Carson",null,null,null,null,"Samantha","Carson"]
[null,"Clinton","Webster","Clinton Webster",null,null,null,null,"Clinton","Webster"]
[null,"Chester","Paul","Chester Paul",null,null,null,null,"Chester","Paul"]
[null,"Rodney","Gomez","Rodney Gomez",null,null,null,null,"Rodney","Gomez"]
[null,"Jaime","Schultz","Jaime Schultz",null,null,null,null,"Jaime","Schultz"]
[null,"Abel","Alvarado","Abel Alvarado",null,null,null,null,"Abel","Alvarado"]
[null,"Rudy","Palmer","Rudy Palmer",null,null,null,null,"Rudy","Palmer"]
[null,"Ryan","Russell","Ryan Russell",null,null,null,null,"Ryan","Russell"]
[null,"Ramiro","Harper","Ramiro Harper",null,null,null,null,"Ramiro","Harper"]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Sqaure Root","index":37,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Find Sqaure Roots of Numbers",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Number","Square Root",null,null,null,null,null,null,"Number","Square Root"]
[null,341,18.466185312619388,null,null,null,null,null,null,341]
[null,244,15.620499351813308,null,null,null,null,null,null,244]
[null,268.25,16.378339354159198,null,null,null,null,null,null,268]
[null,205,14.317821063276353,null,null,null,null,null,null,205]
[null,25,5,null,null,null,null,null,null,25]
[null,169,13,null,null,null,null,null,null,169]
[null,56,7.4833147735478827,null,null,null,null,null,null,56]
[null,7,2.6457513110645907,null,null,null,null,null,null,7]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Cubic Root","index":38,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Finding Cubic Roots of Numbers",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Number","Cube Root",null,null,null,null,null,null,"Number","Cube Root"]
[null,341,6.9863680278181048,null,null,null,null,null,null,341]
[null,244,6.2487997695262427,null,null,null,null,null,null,244]
[null,268,6.4473057272669134,null,null,null,null,null,null,268]
[null,205,5.896368539970366,null,null,null,null,null,null,205]
[null,25,2.924017738212866,null,null,null,null,null,null,25]
[null,169,5.5287748136788712,null,null,null,null,null,null,169]
[null,56,3.8258623655447779,null,null,null,null,null,null,56]
[null,7.42,1.9504491623660241,null,null,null,null,null,null,7]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Odd Even","index":39,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Checking Odd or Even Numbers",null,null,null,null,"Practice Yourself"]
[]
[null,"Number","Odd or Even",null,null,null,"Number","Odd or Even"]
[null,10,"Even",null,null,null,10]
[null,15,"Odd",null,null,null,15]
[null,22,"Even",null,null,null,22]
[null,21,"Odd",null,null,null,21]
[null,50,"Even",null,null,null,50]
[null,35,"Odd",null,null,null,35]
[null,23,"Odd",null,null,null,23]
[null,42,"Even",null,null,null,42]
[null,65,"Odd",null,null,null,65]
[null,24,"Even",null,null,null,24]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Add Hyperlinks","index":40,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Adding Hyperlinks",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Rank","Domain Name","Domain Link",null,null,null,null,null,"Rank","Domain Name","Domain Link"]
[null,1,"Google","Google",null,null,null,null,null,1,"Google"]
[null,2,"Blooger","Blooger",null,null,null,null,null,2,"Blooger"]
[null,3,"Youtube","Youtube",null,null,null,null,null,3,"Youtube"]
[null,4,"LinkedIn","LinkedIn",null,null,null,null,null,4,"LinkedIn"]
[null,5,"Google Support","Google Support",null,null,null,null,null,5,"Google Support"]
[null,6,"WordPress","WordPress",null,null,null,null,null,6,"WordPress"]
[]
[]
[]
[null,"Back to Home Page"]
[]
[]
[]
[null,null,null,null,1]

{"sheet":"Remove Hyperlinks","index":41,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Removing Hyperlinks",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Rank","Domain Name","Domain Link",null,null,null,null,null,"Rank","Domain Name","Domain Link"]
[null,1,"Google","Google",null,null,null,null,null,1,"Google","Google"]
[null,2,"Blooger","Blooger",null,null,null,null,null,2,"Blooger","Blooger"]
[null,3,"Youtube","Youtube",null,null,null,null,null,3,"Youtube","Youtube"]
[null,4,"LinkedIn","LinkedIn",null,null,null,null,null,4,"LinkedIn","LinkedIn"]
[null,5,"Google Support","Google Support",null,null,null,null,null,5,"Google Support","Google Support"]
[null,6,"WordPress","WordPress",null,null,null,null,null,6,"WordPress","WordPress"]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Range into Image","index":42,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Converting Range into an Image",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Order Date","Customer Name","Ship Date",null,null,null,null,"Order No","Order Date","Customer Name","Ship Date"]
[null,"5071-1","2013-05-05","Christopher Schild","2013-05-07",null,null,null,null,"5071-1","2013-05-05","Christopher Schild","2013-05-07"]
[null,"5071-2","2013-05-05","Christopher Schild","2013-05-07",null,null,null,null,"5071-2","2013-05-05","Christopher Schild","2013-05-07"]
[null,"5145-1","1900-07-21T11:13:06.999","Cyma Kinney","2013-05-07",null,null,null,null,"5145-1","1900-07-21T11:13:06.999","Cyma Kinney","2013-05-07"]
[null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10",null,null,null,null,"5145-2","2013-05-29","Cyma Kinney","2013-06-10"]
[null,"5160-1","1900-07-21T13:13:24.362","Berenike Kampe","2013-06-10",null,null,null,null,"5160-1","1900-07-21T13:13:24.362","Berenike Kampe","2013-06-10"]
[null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10",null,null,null,null,"5160-2","2013-06-10","Berenike Kampe","2013-06-10"]
[null,"5168-1","1900-07-21T13:24:01.046","Christy Brittain","2013-06-10",null,null,null,null,"5168-1","1900-07-21T13:24:01.046","Christy Brittain","2013-06-10"]
[null,"5168-2","2013-07-15","Christy Brittain","2013-07-22",null,null,null,null,"5168-2","2013-07-15","Christy Brittain","2013-07-22"]
[null,"5195-1","2013-07-20","Alex Grayson","2013-07-22",null,null,null,null,"5195-1","2013-07-20","Alex Grayson","2013-07-22"]
[null,"5195-2","2013-07-21","Alex Grayson","2013-07-22",null,null,null,null,"5195-2","2013-07-21","Alex Grayson","2013-07-22"]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Blank to Zero","index":43,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Replacing Blank Cells with Zeros",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,"5071-1",2.23,41,{"$f":"K6*L6","v":91.429999999999993}]
[null,"5071-2",6.68,0,{"$f":"C7*D7","v":0},null,null,null,null,"5071-2",6.68,null,0]
[null,"5145-1",5.18,2,10.36,null,null,null,null,"5145-1",5.18,2,10.36]
[null,"5145-2",5.84,0,0,null,null,null,null,"5145-2",5.84,null,0]
[null,"5160-1",2.23,41,91.429999999999993,null,null,null,null,"5160-1",2.23,41,91.429999999999993]
[null,"5160-2",5.4,0,0,null,null,null,null,"5160-2",5.4,null,0]
[null,"5168-1",6.47,20,129.4,null,null,null,null,"5168-1",6.47,20,129.4]
[null,"5168-2",2.84,0,0,null,null,null,null,"5168-2",2.84,null,0]
[null,"5195-1",2.88,11,31.68,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Highlight Blank","index":44,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Highlighting Blank Cells",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,"5071-1",2.23,41,{"$f":"K6*L6","v":91.429999999999993}]
[null,"5071-2",6.68,2,{"$f":"C7*D7","v":13.36},null,null,null,null,"5071-2",6.68,2,{"$f":"K7*L7","v":13.36}]
[null,"5145-1",5.18,null,0,null,null,null,null,"5145-1",5.18,null,0]
[null,"5145-2",5.84,4,23.36,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",2.23,null,0,null,null,null,null,"5160-1",2.23,null,0]
[null,"5160-2",5.4,26,140.4,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",1.5948728690385892,20,31.897457380771783,null,null,null,null,"5168-1",1.5948728690385892,20,31.897457380771783]
[null,"5168-2",2.84,null,0,null,null,null,null,"5168-2",2.84,null,0]
[null,"5195-1",2.88,11,31.68,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Negative Sign","index":45,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Removing Negative Signs",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,"Data","Result"]
[null,24,24,null,null,null,null,null,null,24]
[null,-63,63,null,null,null,null,null,null,-63]
[null,12,12,null,null,null,null,null,null,12]
[null,-23,23,null,null,null,null,null,null,-23]
[null,-31,31,null,null,null,null,null,null,-31]
[null,33,33,null,null,null,null,null,null,33]
[null,-32,32,null,null,null,null,null,null,-32]
[null,-1,1,null,null,null,null,null,null,-1]
[null,4,4,null,null,null,null,null,null,4]
[null,29,29,null,null,null,null,null,null,29]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Insert Time & Date","index":46,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Inserting Time and Date",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Transaction ID","Account","Transaction Type","Entry Time & Date",null,null,null,null,null,null,"Transaction ID","Account","Transaction Type","Entry Time & Date"]
[null,"AB3023001","Cash","Salary","2023-11-21T09:14:40",null,null,null,null,null,null,"AB3023001","Cash"]
[null,"AB3023002","Accounts Receivable","Transfer","2023-11-21T09:14:50",null,null,null,null,null,null,"AB3023002","Accounts Receivable"]
[null,"AB3023003","Office Supplies","Tax Payment","2023-11-21T09:14:55",null,null,null,null,null,null,"AB3023003","Office Supplies"]
[null,"AB3023004","Depreciation Expense","Depreciation","2023-11-21T09:15:23",null,null,null,null,null,null,"AB3023004","Depreciation Expense"]
[null,"AB3023005","Payroll","Salary","2023-11-21T09:15:29",null,null,null,null,null,null,"AB3023005","Payroll"]
[null,"AB3023006","Accounts Payable","Vendor Payment","2023-11-21T09:15:46",null,null,null,null,null,null,"AB3023006","Accounts Payable"]
[null,"AB3023007","Sales Revenue","Sale","2023-11-21T09:15:07",null,null,null,null,null,null,"AB3023007","Sales Revenue"]
[null,"AB3023008","Bank","Transfer","2023-11-21T09:15:50",null,null,null,null,null,null,"AB3023008","Bank"]
[null,"AB3023009","Taxes Payable","Tax Payment","2023-11-21T09:15:53",null,null,null,null,null,null,"AB3023009","Taxes Payable"]
[null,"AB3023010","Inventory","Write-off","2023-11-21T09:15:55",null,null,null,null,null,null,"AB3023010","Inventory"]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Remove Time","index":47,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Removing Time from Time & Date",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Order Date","Ship Date",null,null,null,null,"Order No","Customer Name","Order Date","Ship Date"]
[null,"5071-1","Christopher Schild","2013-05-05","2013-05-07",null,null,null,null,"5071-1","Christopher Schild","2013-05-05T00:05:00","2013-05-07T11:30:00"]
[null,"5071-2","Christopher Schild","2013-05-05","2013-05-07",null,null,null,null,"5071-2","Christopher Schild","2013-05-05T07:00:00","2013-05-07T02:00:00"]
[null,"5145-1","Cyma Kinney","1900-07-21","2013-05-07",null,null,null,null,"5145-1","Cyma Kinney","1900-07-21T11:13:06.999","2013-05-07T09:20:00"]
[null,"5145-2","Cyma Kinney","2013-05-29","2013-06-10",null,null,null,null,"5145-2","Cyma Kinney","2013-05-29T09:30:00","2013-06-10T02:15:00"]
[null,"5160-1","Berenike Kampe","1900-07-21","2013-06-10",null,null,null,null,"5160-1","Berenike Kampe","1900-07-21T13:13:24","2013-06-10T08:00:00"]
[null,"5160-2","Berenike Kampe","2013-06-10","2013-05-07",null,null,null,null,"5160-2","Berenike Kampe","2013-06-10T06:33:00","2013-05-07T11:30:00"]
[null,"5168-1","Christy Brittain","2013-05-05","2013-05-07",null,null,null,null,"5168-1","Christy Brittain","2013-05-05T00:05:00","2013-05-07T02:00:00"]
[null,"5168-2","Christy Brittain","2013-05-05","2013-05-07",null,null,null,null,"5168-2","Christy Brittain","2013-05-05T07:00:00","2013-05-07T09:20:00"]
[null,"5195-1","Alex Grayson","1900-07-21","2013-06-10",null,null,null,null,"5195-1","Alex Grayson","1900-07-21T11:13:06.999","2013-06-10T02:15:00"]
[null,"5195-2","Alex Grayson","2013-05-29","2013-06-10",null,null,null,null,"5195-2","Alex Grayson","2013-05-29T09:30:00","2013-06-10T08:00:00"]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Remove Date","index":48,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Removing Date from Time & Date",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Customer Name","Order Date","Ship Date",null,null,null,null,"Order No","Customer Name","Order Date","Ship Date"]
[null,"5071-1","Christopher Schild","00:05:00","11:30:00",null,null,null,null,"5071-1","Christopher Schild","2013-05-05T00:05:00","2013-05-07T11:30:00"]
[null,"5071-2","Christopher Schild","07:00:00","02:00:00",null,null,null,null,"5071-2","Christopher Schild","2013-05-05T07:00:00","2013-05-07T02:00:00"]
[null,"5145-1","Cyma Kinney","11:13:06.999","09:20:00",null,null,null,null,"5145-1","Cyma Kinney","1900-07-21T11:13:06.999","2013-05-07T09:20:00"]
[null,"5145-2","Cyma Kinney","09:30:00","02:15:00",null,null,null,null,"5145-2","Cyma Kinney","2013-05-29T09:30:00","2013-06-10T02:15:00"]
[null,"5160-1","Berenike Kampe","13:13:24","08:00:00",null,null,null,null,"5160-1","Berenike Kampe","1900-07-21T13:13:24","2013-06-10T08:00:00"]
[null,"5160-2","Berenike Kampe","06:33:00","11:30:00",null,null,null,null,"5160-2","Berenike Kampe","2013-06-10T06:33:00","2013-05-07T11:30:00"]
[null,"5168-1","Christy Brittain","00:05:00","02:00:00",null,null,null,null,"5168-1","Christy Brittain","2013-05-05T00:05:00","2013-05-07T02:00:00"]
[null,"5168-2","Christy Brittain","07:00:00","09:20:00",null,null,null,null,"5168-2","Christy Brittain","2013-05-05T07:00:00","2013-05-07T09:20:00"]
[null,"5195-1","Alex Grayson","11:13:06.999","02:15:00",null,null,null,null,"5195-1","Alex Grayson","1900-07-21T11:13:06.999","2013-06-10T02:15:00"]
[null,"5195-2","Alex Grayson","09:30:00","08:00:00",null,null,null,null,"5195-2","Alex Grayson","2013-05-29T09:30:00","2013-06-10T08:00:00"]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Range To Array","index":49,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,2,6],[2,10,2,15]]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Converting Range into Array",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,null,null,null,null,"Total Marks",300,null,null,null,null,null,null,null,"Total Marks",300]
[]
[null,"ID","Name","Math","Physics","Chemistry","Percentage",null,null,null,"ID","Name","Math","Physics","Chemistry","Percentage"]
[null,1210009,"Tracy Blumstein",48,74,43,{"$f":"SUM(D8:F8)/$G$5","v":0.55000000000000004},null,null,null,1210009,"Tracy Blumstein",48,74,43,{"$f":"SUM(M8:O8)/$G$5","v":0.55000000000000004}]
[null,1210046,"Gene Hale",58,51,56,{"$f":"SUM(D9:F9)/$G$5","v":0.55000000000000004},null,null,null,1210046,"Gene Hale",58,51,56,{"$f":"SUM(M9:O9)/$G$5","v":0.55000000000000004}]
[null,1210034,"Steve Nguyen",72,54,40,0.55333333333333334,null,null,null,1210034,"Steve Nguyen",72,54,40,0.55333333333333334]
[null,1210043,"Harold Pawlan",41,87,50,0.59333333333333338,null,null,null,1210043,"Harold Pawlan",41,87,50,0.59333333333333338]
[null,1210041,"Alejandro Grove",90,56,41,0.62333333333333329,null,null,null,1210041,"Alejandro Grove",90,56,41,0.62333333333333329]
[null,1210087,"Andrew Allen",67,45,76,0.62666666666666671,null,null,null,1210087,"Andrew Allen",67,45,76,0.62666666666666671]
[null,1210081,"Ken Black",90,59,42,0.63666666666666671,null,null,null,1210081,"Ken Black",90,59,42,0.63666666666666671]
[null,1210031,"Emily Burns",69,69,57,0.65,null,null,null,1210031,"Emily Burns",69,69,57,0.65]
[null,1210008,"Sandra Flanagan",78,77,42,0.65666666666666662,null,null,null,1210008,"Sandra Flanagan",78,77,42,0.65666666666666662]
[null,1210096,"Pete Kriz",68,69,65,0.67333333333333334,null,null,null,1210096,"Pete Kriz",68,69,65,0.67333333333333334]
[null,1210063,"Zuschuss Donatelli",90,56,66,0.70666666666666667,null,null,null,1210063,"Zuschuss Donatelli",90,56,66,0.70666666666666667]
[]
[]
[null,"Back to Home Page"]

{"sheet":"CSV to XLSX","index":50,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Converting CSV Data into XLSX",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Order Hour","Customer Name","Ship Hour",null,null,null,null,"Order No","Order Hour","Customer Name","Ship Hour"]
[null,"5071-1","00:05:00","Christopher Schild","11:30:00",null,null,null,null,"5071-1","2013-05-05T00:05:00","Christopher Schild","2013-05-07T11:30:00"]
[null,"5071-2","07:00:00","Christopher Schild","02:00:00",null,null,null,null,"5071-2","2013-05-05T07:00:00","Christopher Schild","2013-05-07T02:00:00"]
[null,"5145-1","11:13:06.999","Cyma Kinney","09:20:00",null,null,null,null,"5145-1","1900-07-21T11:13:06.999","Cyma Kinney","2013-05-07T09:20:00"]
[null,"5145-2","09:30:00","Cyma Kinney","02:15:00",null,null,null,null,"5145-2","2013-05-29T09:30:00","Cyma Kinney","2013-06-10T02:15:00"]
[null,"5160-1","13:13:24","Berenike Kampe","08:00:00",null,null,null,null,"5160-1","1900-07-21T13:13:24","Berenike Kampe","2013-06-10T08:00:00"]
[null,"5160-2","06:33:00","Berenike Kampe","11:30:00",null,null,null,null,"5160-2","2013-06-10T06:33:00","Berenike Kampe","2013-05-07T11:30:00"]
[null,"5168-1","00:05:00","Christy Brittain","02:00:00",null,null,null,null,"5168-1","2013-05-05T00:05:00","Christy Brittain","2013-05-07T02:00:00"]
[null,"5168-2","07:00:00","Christy Brittain","09:20:00",null,null,null,null,"5168-2","2013-05-05T07:00:00","Christy Brittain","2013-05-07T09:20:00"]
[null,"5195-1","11:13:06.999","Alex Grayson","02:15:00",null,null,null,null,"5195-1","1900-07-21T11:13:06.999","Alex Grayson","2013-06-10T02:15:00"]
[null,"5195-2","09:30:00","Alex Grayson","08:00:00",null,null,null,null,"5195-2","2013-05-29T09:30:00","Alex Grayson","2013-06-10T08:00:00"]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Advanced Filter","index":51,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Using Advanced Filter to Range",null,null,null,null,null,null,null,null,null,null,"Using Advanced Filter to Range"]
[]
[null,"Brand","Device","Release Date","Price",null,"Brand","Device",null,null,null,null,"Brand","Device","Release Date","Price",null,"Brand","Device"]
[null,"Gamind","Notebook","2021-02-17",620,null,"Omicron","Desktop",null,null,null,null,"Gamind","Notebook","2021-02-17",620,null,"Omicron","Desktop"]
[null,"Gamind","Desktop","2021-04-12",800,null,null,null,null,null,null,null,"Gamind","Desktop","2021-04-12",800]
[null,"Gamind","Notebook","2021-05-19",860,null,"Brand","Device","Release Date","Price",null,null,"Gamind","Notebook","2021-05-19",860]
[null,"Gamind","Desktop","2021-01-19",870,null,"Omicron","Desktop","2021-05-25",880,null,null,"Gamind","Desktop","2021-01-19",870]
[null,"Omicron","Desktop","2021-05-25",880,null,"Omicron","Desktop","2021-02-15",920,null,null,"Omicron","Desktop","2021-05-25",880]
[null,"Omicron","Desktop","2021-02-15",920,null,"Omicron","Desktop","2021-03-24",980,null,null,"Omicron","Desktop","2021-02-15",920]
[null,"Omicron","Desktop","2021-03-24",980,null,null,null,null,null,null,null,"Omicron","Desktop","2021-03-24",980]
[null,"Omicron","Notebook","2021-02-04",1000,null,null,null,null,null,null,null,"Omicron","Notebook","2021-02-04",1000]
[null,"Codemy","Desktop","2021-06-16",490,null,null,null,null,null,null,null,"Codemy","Desktop","2021-06-16",490]
[null,"Codemy","Notebook","2021-07-07",650,null,null,null,null,null,null,null,"Codemy","Notebook","2021-07-07",650]
[null,"Codemy","Notebook","2021-01-01",1200,null,null,null,null,null,null,null,"Codemy","Notebook","2021-01-01",1200]
[]
[]
[]
[]
[]
[null,"Home Page"]

{"sheet":"Extract Comments","index":52,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Top 50 Useful Examples of Macros in Excel VBA",null,null,null,null,null,null,null,"Top 50 Useful Examples of Macros in Excel VBA"]
[]
[null,"Extract Comments from Range",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Total","Comments",null,null,null,"Order No","Retail Price","Order Quantity","Total","Comments"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},"Paid in Cash",null,null,null,"5071-1",2.23,41,{"$f":"K6*L6","v":91.429999999999993}]
[null,"5071-2",6.68,2,13.36,"Bank Deposit",null,null,null,"5071-2",6.68,2,13.36]
[null,"5145-1",5.18,2,10.36,"Purchased Failed",null,null,null,"5145-1",5.18,2,10.36]
[null,"5145-2",5.84,4,23.36,"\n Paid in Cash",null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",2.23,41,91.429999999999993,"Transaction Pending",null,null,null,"5160-1",2.23,41,91.429999999999993]
[null,"5160-2",5.4,26,140.4,"Bank Deposit",null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",1.5948728690385892,20,31.897457380771783,"Paid in Cash",null,null,null,"5168-1",1.5948728690385892,20,31.897457380771783]
[null,"5168-2",2.84,39,110.75999999999999,"Bank Draft",null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,"Order Cancelled",null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,"Bank Draft",null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]