{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Úvod","With"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"Úvod","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,27,11],[1,2,1,9],[2,2,2,9],[12,2,13,6],[15,3,16,6],[16,7,16,9]]}
[]
[null,null,"Jak na Excel "]
[null,null,"MUNI"]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"With"]
[null,null,null,null,"využití v následujicích lekcích"]
[]
[]
[]
[]
[null,null,"Pavel Lasák"]
[]
[]
[null,null,null,"Lektor, expert na Microsoft Excel, držitel prestižního ocenění Microsoftu MVP v České republice"]
[null,null,null,null,null,null,null,5002722]
[]
[]
[]
[]
[null,null,null,"Další informace ke cvičení:"]
[null,null,null,null,"http://office.lasakovi.com/excel/vba-teorie-zaklady/with-end-with-excel-vba/"]
[]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2017"]

{"sheet":"With","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,0,2,7],[3,0,3,7]]}
["pokus"]
[]
["With  … End"]
["http://office.lasakovi.com"]
[]
[null,"SYNTAXE"]
[null,"With objekt "]
[null,"    [příkazy] "]
[null,"End With"]
[]
[null,"Poznámka: posloupnost příkazů pro jeden objekt"]
[]
[null,"Zabarvit v List1 buňku A1"]
[]
[null,"With Worksheets(\"List1\").Range(\"A1\")"]
[null,null,".Value = 30"]
[null,null,".Font.Bold = True"]
[null,null,".Interior.Color = RGB(255, 255, 0)"]
[null,"End With"]