{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Home Page","Dataset Overview","Selecting a Single Cell","Selecting All Cells With Data","Selecting Last Cell in a Column","Reading Cell Value","Get Cell Value Into Variable","Changing Number Format","Changing Fill Color","Changing Font Style, Size","Copy and Paste Cells","Counting Cells in a Range","Counting Cells Criteria","Setting Cell Value","Clearing Cells","Defining Range","Splitting Comment From Cells","Splitting Notes From Cells","Changing Cell Reference","Referring Non-Contiguous Cells","Find Cells with Duplicate Value"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":3,"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":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"VBA Cells in Excel"]
[null,"Learn about VBA Cells in Excel. Go through the article and practice the in practice section."]
[]
[null,"Prepared By","Nasir Muhammad Munim"]
[null,"Reviewed By","Seemanto Saha"]
[null,"Last Update","2023-11-28"]
[null,"Article Link","VBA Cells in Excel"]
[]
[null,"Contents"]
[null,"Dataset Overview"]
[null,"How to Select Cells in Excel using VBA"]
[null,"   1. Selecting a Single Cell"]
[null,"   2. Selecting All Cells With Data"]
[null,"   3. Selecting Last Cell in a Column"]
[null,"How to Get Cell Value Using VBA in Excel"]
[null,"   1. Reading Cell Value"]
[null,"   2. Get Cell Value Into Variable"]
[null,"How to Format Cells in Excel Using VBA"]
[null,"   1. Changing Number Format"]
[null,"   2. Changing Fill Color"]
[null,"   3. Changing Font Style, Size, and Color"]
[null,"How to Copy and Paste Cells in Excel Using VBA"]
[null,"How to Count Cells in Excel Using VBA"]
[null,"   1. Counting Cells in a Range"]
[null,"   2. Counting Cells Based on Criteria"]
[null,"Using Cell Properties in Excel VBA: 8 Examples"]
[null,"   1. Setting Cell Value"]
[null,"   2. Clearing Cells"]
[null,"   3. Defining Range"]
[null,"   4. Splitting Comment From Cells"]
[null,"   5. Splitting Notes From Cells"]
[null,"   6. Changing Cell Reference With the OFFSET Function"]
[null,"   7. Referring to Non-Contiguous Cells"]
[null,"   8. Finding Cells with Duplicate Values"]
[]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Dataset Overview","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Dataset Overview"]
[]
[null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98}]
[null,"5071-3",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Selecting a Single Cell","index":2,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Selecting a Single Cell",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Selecting All Cells With Data","index":3,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,0,4],[2,1,2,4]]}
[null,"VBA Cells in Excel"]
[]
[null,"Selecting All Cells With Data",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Selecting Last Cell in a Column","index":4,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Selecting Last Cell in a Column",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Reading Cell Value","index":5,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Reading Cell Value",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Get Cell Value Into Variable","index":6,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Getting Cell Value Into Variable",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Changing Number Format","index":7,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Changing Number Format",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Changing Fill Color","index":8,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Changing Fill Color",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Changing Font Style, Size","index":9,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Changing Font Style, Size, and Color",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5145-1",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5145-2",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5160-1",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5160-2",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5168-1",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5168-2",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5195-1",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5195-2",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Copy and Paste Cells","index":10,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"How to Copy and Paste Cells in Excel Using VBA",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},41,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},2,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,1,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,4,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,41,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Counting Cells in a Range","index":11,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Counting Cells in a Range",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Counting Cells Criteria","index":12,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Counting Cells Based on Criteria",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Setting Cell Value","index":13,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Setting Cell Value",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",5,41,{"$f":"C6*D6","v":205},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Clearing Cells","index":14,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Clearing Cells",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,null,null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,null,null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,null,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,null,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,null,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,null,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,null,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,null,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,null,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,null,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Defining Range","index":15,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Defining Range",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Splitting Comment From Cells","index":16,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Splitting Comment From Cells",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total","Comments",null,null,null,null,"Order No","Retail Price","Order Quantity","Total","Comments"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82}," Bank deposit ",null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98}," Paid in cash ",null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5," Paid in cash ",null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009," Transaction pending ",null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59," Purchase failed ",null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74," Bank deposit ",null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011," Paid in cash ",null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5," Bank draft ",null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89," Order cancelled ",null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5," Bank deposit ",null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Splitting Notes From Cells","index":17,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Splitting Notes From Cells",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total","Notes",null,null,null,null,"Order No","Retail Price","Order Quantity","Total","Notes"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},"Munim Nayeem:\nBank deposit",null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},"Munim Nayeem:\nPaid in Cash",null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,"Munim Nayeem:\nPaid in cash",null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,"Munim Nayeem:\nTransaction pending",null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,"Munim Nayeem:\nPurchase failed",null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,"Munim Nayeem:\nBank deposit",null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,"Munim Nayeem:\nPaid in cash",null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,"Munim Nayeem:\nBank draft",null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,"Munim Nayeem:\nOrder cancelled",null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,"Munim Nayeem:\nBank deposit",null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Changing Cell Reference","index":18,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Changing Cell Reference With the OFFSET Function",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Referring Non-Contiguous Cells","index":19,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Referring to Non-Contiguous Cells",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",5,1,5,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.5,39,97.5,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Find Cells with Duplicate Value","index":20,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Cells in Excel"]
[]
[null,"Finding Cells with Duplicate Values",null,null,null,null,null,null,null,null,"Try the Method by Yourself Here"]
[]
[null,"Order No","Retail Price","Order Quantity","Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,"5071-3",4.99,1,4.99,null,null,null,null,null,"5145-1",5,1,5]
[null,"5071-4",2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,"5145-2",2.4900000000000002,4,9.9600000000000009]
[null,"5071-5",4.99,41,204.59,null,null,null,null,null,"5160-1",4.99,41,204.59]
[null,"5071-6",5.49,26,142.74,null,null,null,null,null,"5160-2",5.49,26,142.74]
[null,"5071-7",3.99,20,79.800000000000011,null,null,null,null,null,"5168-1",3.99,20,79.800000000000011]
[null,"5071-8",2.4900000000000002,39,97.110000000000014,null,null,null,null,null,"5168-2",2.5,39,97.5]
[null,"5071-9",2.99,11,32.89,null,null,null,null,null,"5195-1",2.99,11,32.89]
[null,"5071-10",5.5,43,236.5,null,null,null,null,null,"5195-2",5.5,43,236.5]
[]
[]
[null,"Back to Home Page"]