{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Úvod","Teorie objektový model","Ukázky","List1","List2","Pokusy"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":0,"defined_names":2,"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,"Objektový model"]
[null,null,null,null,"Select"]
[]
[]
[]
[]
[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-listy-bunky/excel-vba-vybirat-oznacovat-bunky/"]
[]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2017"]

{"sheet":"Teorie objektový model","index":1,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["Select - Excel VBA"]
["http://office.lasakovi.com/"]
[]
[]
[null,"sešit ve kterém se kód nachází"]
[null,"ThisWorkbook.Worksheets(\"List1\").Range(\"A3\").Value = \"Ahoj\""]
[]
[null,"Aktivní sešit (mže být i jiný než ve kterém je kód)"]
[null,"ActiveWorkbook.Worksheets(\"List1\").Range(\"A3\").Value = \"Ahoj\""]
[]
[null,"sešit ve kterém se kód nachází"]
[null,"ThisWorkbook.Sheets(\"List1\").Range(\"A3\").Value = \"Ahoj\""]
[]
[null,"Sheets je nadřazený"]
[null,"Worksheets"]
[null,"Chart Sheets"]
[]
[null,"Zjednodušení pokud jsme si jistý na kterém jsem listu"]
[null,"Range(\"A3\").Value = \"Ahoj\""]
[]
[]
[null,"tip:"]
[null,"Sheets - collection of the Sheets of all types"]
[null,"Worksheets - collection of Sheets of type Worksheet"]
[null,"Charts - collection of Sheets of type Chart Sheet"]

{"sheet":"Ukázky","index":2,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,8],[50,0,50,8],[51,0,52,4],[1,0,1,8]]}
["Select - Excel VBA"]
["http://office.lasakovi.com/"]
[null,null,null,null,null,null,null,null,null,null,"Vyber (označ) na daném listě"]
[null,null,null,null,null,null,null,null,null,null,"Range(\"B4\").Select"]
[]
[null,null,null,null,null,null,null,null,null,null,"Cells(4, 2).Select"]
[]
[null,null,null,null,null,null,null,null,null,null,"Označit přes aktivní sešit"]
[null,null,null,null,null,null,null,null,null,null,"ActiveSheet.Range(\"B4\").Select","Úkol: Jak přehodit na jinou buňku?"]
[]
[null,null,null,null,null,null,null,null,null,null,"ActiveSheet.Cells(4, 2).Select"]
[]
[]
[null,"Jiný list",null,null,null,null,null,null,null,null,"Jiný list"]
[null,null,null,null,null,null,null,null,null,null,"Sheets(\"List2\").Activate"]
[null,null,null,null,null,null,null,null,null,null,"ActiveSheet.Range(\"B3\").Select"]
[]
[null,null,null,null,null,null,null,null,null,null,"Application.Goto ActiveWorkbook.Sheets(\"List2\").Cells(3, 2)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Oblast"]
[null,null,null,null,null,null,null,null,null,null,"Range(\"B23:C26\").Select"]
[]
[null,null,null,null,null,null,null,null,null,null,"Range(\"B23\", \"C26\").Select"]
[]
[null,null,null,null,null,null,null,null,null,null,"Range(Cells(23, 2), Cells(26, 3)).Select"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Oblast v oblassti"]
[null,null,null,null,null,null,null,null,null,null,"Co provede?"]
[null,null,null,null,null,null,null,null,null,null,"Range(\"B32:F35\").Cells(2, 2).Select"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Pojmenovaná (definovaná oblast)"]
[]
[null,"Test",null,null,null,null,null,null,null,null,"Range(\"Test\").Select"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Které buňky vybrány, co když označím dvě?"]
[null,null,null,null,null,null,null,null,null,null,"Dim Bunka As Range"]
[null,null,null,null,null,null,null,null,null,null,"For Each Bunka In Selection"]
[null,null,null,null,null,null,null,null,null,null,"    MsgBox \"Vybraný řádek je \" & Bunka.Row"]
[null,null,null,null,null,null,null,null,null,null,"    MsgBox \"Vybraný sloupec je \" & Bunka.Column"]
[null,null,null,null,null,null,null,null,null,null,"Next Bunka"]
[]
["Příklad k článku:"]
["http://office.lasakovi.com/excel/vba-listy-bunky/excel-vba-vybirat-oznacovat-bunky/"]
["Pavel Lasák 2017"]

{"sheet":"List1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Pokusy","index":5,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[47,0,47,7],[20,0,20,7],[20,9,20,16]]}
["Select - Excel VBA"]
["http://office.lasakovi.com/"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["BUŇKA",null,null,null,null,null,null,null,null,"Uložit obsah do proměnné"]
[]
[null,"Označovat buňku"]
[null,null,null,null,null,null,null,null,null,"Dim MojeOblast As Range"]
[null,"Range(\"B4\").Select",null,null,null,null,null,null,null,"Set MojeOblast = Range(\"B4\")"]
[null,null,null,null,null,null,null,null,null,"MojeOblast.Select"]
[null,"Range(\"Nazev\").Select"]
[]
[null,"Cellls(4,2).Select"]
[]
[null,"Označovat buňku v aktivním listu"]
[]
[null,"ActiveSheet.Range(\"B4\").Select"]
[]
[null,"ActiveSheet.Cells(4, 2).Select"]
[]
[]
[null,"Označovat buňku jiný list"]
[]
[null,"Sheets(2).Activate",null,null,null,null,"Pořadí listu"]
[null,"ActiveSheet.Range(\"B3\").Select"]
[]
[null,"Sheets(\"List2\").Activate",null,null,null,null,"Název Listu"]
[null,"ActiveSheet.Range(\"B3\").Select"]
[]
[null,"Application.Goto ActiveWorkbook.Sheets(\"List2\").Cells(3, 2)"]
[]
["OBLAST"]
[]
[null,"Označovat oblast buněk"]
[]
[null,"ActiveSheet.Range(Cells(10, 2), Cells(13, 3)).Select"]
[]
[null,"ActiveSheet.Range(\"B10:C13\").Select"]
[]
[null,"ActiveSheet.Range(\"B10\", \"C13\").Select"]
[]
[null,"ActiveSheet.Range(\"B4:F10\").Select"]
[]
[null,"ActiveSheet.Range(\"B4:F10\").Cells(2,2).Select"]
[]
[]
[null,"Dynamicky"]