{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Úvod","With teorie","With","With jinde","Prostor pro poznámky"],"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":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,11],[1,2,1,9],[11,2,12,6],[14,3,15,6],[15,7,15,9]]}
[]
[null,null,"Jak na Excel "]
[]
[]
[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,null,null,null,"https://office.lasakovi.com/excel/vba-listy-sheet/jak-na-listy-sheet-VBA-Excel/"]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2017 rev 2019"]

{"sheet":"With teorie","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
["With  … End"]
["http://office.lasakovi.com"]
[]
[]
[null,"With objekt "]
[null,"    [příkazy] "]
[null,"End With"]
[]
[]
[null,"Doporučení"]
[null,"Využijete až probereme práci s buňkami oblastmi"]

{"sheet":"With","index":2,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,2,7],[3,0,3,7]]}
["pokus"]
[]
["With  … End"]
["http://office.lasakovi.com"]
[]
[null,null,null,null,"Prakticky"]
[null,"Náhrada a zpřehlednění",null,null,"Zabarvit v List1 buňku A1"]
[null,"ActiveCell.Font.Bold = True"]
[null,"ActiveCell.Font.Color = vbBlue",null,null,"With Worksheets(\"List1\").Range(\"A1\")"]
[null,"ActiveCell.Font.Name = \"Arial\"",null,null,null,".Value = 30"]
[null,"ActiveCell.Font.Size = 22",null,null,null,".Font.Bold = True"]
[null,"ActiveCell.Font.Italic = True",null,null,null,".Interior.Color = RGB(255, 255, 0)"]
[null,null,null,null,"End With"]
[null,"Zpřehlednění a zrychlení kódu"]
[]
[null,"With ActiveCell.Font"]
[null,".Bold = True"]
[null,".Color = vbBlue"]
[null,".Name = \"Arial\""]
[null,".Size = 22"]
[null,".Italic = True"]
[null,"End With"]

{"sheet":"With jinde","index":3,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,1,48,10],[5,1,5,10],[22,1,22,10],[30,1,30,10],[0,0,0,11],[1,0,1,11]]}
["With  … End"]
["http://office.lasakovi.com"]
[]
[]
[]
[null,"Do sešitu …. Listu …. Buňky zapiš vzorec a naformatuj ho"]
[]
[null,"With Workbooks(\"MujSešit\").Worksheets(\"List1\").Cells(1, 1)"]
[null,null,".Formula = \"=SQRT(25)\""]
[null,null,"With .Font"]
[null,null,null,".Name = \"Arial\""]
[null,null,null,".Bold = True"]
[null,null,null,".Size = 8"]
[null,null,"End With"]
[null,"End With"]
[]
[null,null,"Poznámka:"]
[null,null,"Viz další kapitoly kde se využije"]
[null,null,"Formátováná"]
[]
[]
[]
[null,"Pokud máte označenou buňku"]
[]
[null,"With Selection.Font "]
[null,"   .Name = \"Arial\" "]
[null,"   .Size = 12 "]
[null,"End With "]
[]
[]
[null,"Práce se zahlavím a zápatím"]
[]
[null,"' vlozit do zahlavi - texty z buněk."]
[null,"With ActiveSheet.PageSetup "]
[null,null,".LeftHeader = Range(\"A1\") "]
[null,null,".CenterHeader = Range(\"A2\") "]
[null,null,".RightHeader = Range(\"A3\") "]
[null,"End With"]
[]
[null,"' Pro zapati:"]
[null,"With ActiveSheet.PageSetup "]
[null,null,".LeftFooter = \"&P\" ' aktualni stranka"]
[null,null,"' &N pocet stranek  ... D datum, T cas"]
[null,null,".CenterFooter = \"Text zadaný přímo\" "]
[null,null,".RightFooter = \"\" "]
[null,"End With"]
[]
[]
[null,"Pro vaše kódy a poznámky"]

{"sheet":"Prostor pro poznámky","index":4,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
["With  … End"]
["http://office.lasakovi.com"]
[]
[null,"Prostor pro vaše poznámky"]