{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Úvod","List2","Vybrat Select Activate","Buňky","Oblasti","Jiné listy","Speciálnosti","Current Used","Řádky sloupce","Formát dat","Ostatní tipy","Sloucene","List3","Pokusy"],"not_rendered":{"charts":0,"images":85,"macros":1,"external_links":0,"defined_names":5,"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":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,11],[1,2,1,9],[15,2,16,6],[18,3,19,6],[19,7,19,9]]}
[]
[null,null,"Jak na Excel  - VBA"]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"Select Activate - rozdíl"]
[null,null,null,null,"Buňka - jak vybrat"]
[null,null,null,null,"Select oblasti"]
[null,null,null,null,"Select jiné listy"]
[null,null,null,null,"Speciálnosti u výběru"]
[null,null,null,null,"Řádky Sloupce"]
[null,null,null,null,"CurrentRegion"]
[]
[]
[]
[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,null,null,null,"https://office.lasakovi.com/excel/vba-listy-bunky/vba-exce-objekt-range-oblast-bunek/"]
[null,null,null,null,"https://office.lasakovi.com/excel/vba-listy-bunky/CurrentRegion-UsedRange-Excel-VBA/"]
[]
[]
[null,"Copyright, Pavel Lasák 2017, rev 2019, rev 2020, 2023"]

{"sheet":"List2","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Pomocný list pro ukázky práci s více listy"]
[]
[]
[]
[]
[null,null,null,null,null,"Tip pokud nepůjde spustit"]
[null,"viz jiné listy"]
[null,"pouze pomůcka"]
[]
[]
[null,"Pokus"]

{"sheet":"Vybrat Select Activate","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[32,0,32,8],[34,0,35,4],[14,1,14,6],[3,2,3,7],[4,2,4,7],[5,2,5,7],[20,1,20,6],[22,2,22,7],[24,2,24,7],[27,2,27,7],[25,2,25,7],[30,1,30,6]]}
["Vybraná buňka - vybrat - Select (Activate)"]
["http://office.lasakovi.com/"]
[]
[null,"Složka","04_VBA_Bunky"]
[null,"Sešit","04c - VBA Bunky - Select-Activate-vybrat.xlsm"]
[null,"List","Vybrat Select Activate"]
[]
[null,"Select","lze použít pro výběr více prvků",null,"Activate","aktivní pouze jeden prvek (buňka, list)"]
[]
[]
[]
[null,null,"Range(\"A12:A13\").Select",null,null,"Range(\"B12:B13\").Activate"]
[]
[]
[null,"Pokud budu chtít ve vybrané oblasti něco změnit, zapsat, podrobněji dále, jen pro dokreslení"]
[]
[null,null,"Selection.Value = 35",null,null,"ActiveCell.Value = 42"]
[null,null," Co se přepíše bude-li označeno více buněk?",null,null,"' Co se přepíše budeli označeno více buněk?"]
[null,null,35,null,null,"' …"]
[]
[null,"Application > Workbook > Worksheet > Range"]
[]
[null,null,"Syntaxe"]
[]
[null,null,"Range(bunka_start [,bunka_konec])"]
[null,null,"Range(Cells(řádek,sloupec) [,Cells(řádek_konec,sloupec_konec)])"]
[]
[null,null,"Cells(řádek,sloupec)"]
[]
[]
[null,"Setování"]
[]
["http://office.lasakovi.com/excel/vba-listy-bunky/excel-vba-vybirat-oznacovat-bunky/"]
[]
["Pavel Lasák 2017 rev 2020, 2021"]

{"sheet":"Buňky","index":3,"n_rows":77,"n_cols":13,"rows_kept":77,"cut":false,"hidden":false,"merged":[[76,0,77,4],[0,0,0,6],[75,0,75,6],[1,0,1,6],[69,2,69,7],[70,2,70,7],[71,2,71,7],[28,1,28,6],[51,1,51,6]]}
["Select BUŇKA - Excel VBA",null,null,null,null,null,null,null,"Select",null,"Activate",null,"Apple"]
["http://office.lasakovi.com/"]
[null,null,null,null,null,null,null,null,"Vyber (označ) na daném listě využít Select",null,"Vyber (označ) na daném listě využít Activate"]
[null,null,null,null,null,null,null,null,"Range(\"B4\").Select",null,"Range(\"B4\").Activate"]
[null,null,null,"Range(\"B4\").Select",null,null,null,null,"Cells(4, 2).Select",null,"Cells(4, 2).Activate"]
[null,null,null,null,null,null,null,null,"Cells(4, \"B\").Select",null,"Cells(4, \"B\").Activate"]
[]
[]
[null,null,null,"Cells(4, 2).Select",null,null,null,null,"Speciál"]
[null,null,null,null,null,null,null,null,"[B4].Select",null,"[B4].Activate"]
[]
[]
[null,null,null,"Cells(4, \"B\").Select"]
[]
[]
[]
[null,null,null,"[B4].Select"]
[]
[]
[null,"Opakovaní využítím dynamických proměných"]
[null,null,null,null,null,null,null,null,"Syntaxe"]
[null,null,null,"Radek = 4\nRange(\"B\" & Radek).Select",null,null,null,null,"Range(bunka_start [,bunka_konec])"]
[null,null,null,null,null,null,null,null,"Range(Cells(řádek,sloupec) [,Cells(řádek_konec,sloupec_konec)])"]
[null,null,null,"Radek = 4\nSloupec = 2\nCells(Radek, Sloupec).Select",null,null,null,null,"Cells(řádek,sloupec)"]
[]
[null,null,null,"' Vyzkoušejte si další možnosti"]
[]
[]
[null,"Využitím ActiveSheet"]
[null,null,null,null,null,null,null,null,"Označit přes aktivní sešit"]
[null,null,null,null,null,null,null,null,"ActiveSheet.Range(\"B31\").Select"]
[null,null,null,"ActiveSheet.Range(\"B31\").Select",null,null,null,null,"ActiveSheet.Cells(31, 2).Select"]
[null,null,null,null,null,null,null,null,"ActiveSheet.Cells(31, \"B\").Select"]
[]
[null,null,null,null,null,null,null,null,"Speciál"]
[null,null,null,"ActiveSheet.Cells(31, 2).Select",null,null,null,null,"ActiveSheet.[B12].Select"]
[]
[null,null,null,null,null,null,null,null,"Kodové jméno listu"]
[null,null,null,null,null,null,null,null,"List1.[B12].Select"]
[null,null,null,"ActiveSheet.Cells(31, \"B\").Select"]
[]
[]
[]
[null,null,null,"ActiveSheet.[B31].Select"]
[]
[]
[]
[null,null,null,"List1.[B31].Select"]
[]
[]
[]
[null,"Využitím  názvu listu"]
[]
[]
[null,null,null,"Worksheets(\"Buňky\").Range(\"B54\").Select"]
[]
[]
[]
[null,null,null,"Sheets(\"Buňky\").Range(\"B54\").Select"]
[]
[]
[]
[null,null,null,"Worksheets(4).Range(\"B54\").Select"]
[]
[]
[]
[null,null,null,"Application.Worksheets(4).Range(\"B54\").Select"]
[]
[]
[null,"Složka","04_VBA_Bunky"]
[null,"Sešit","04c - VBA Bunky - Select-Activate-vybrat.xlsm"]
[null,"List","Buňky"]
[]
[]
[]
["http://office.lasakovi.com/excel/vba-listy-bunky/excel-vba-vybirat-oznacovat-bunky/"]
["Pavel Lasák 2017 rev 2020"]

{"sheet":"Oblasti","index":4,"n_rows":62,"n_cols":18,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[61,0,62,9]]}
["Select OBLASTI  - Excel VBA"]
["https://office.lasakovi.com/"]
[null,null,null,null,null,null,null,null,null,"Oblasti",null,null,"Testy"]
[null,null,null,null,null,null,null,null,null,"<<<< využijete pro dynamické procházení tabulek",null,null,null,null,null,null,null,"Apple"]
[null,null,null,null,null,null,null,null,null,"Range(\"B4:G10\").Select"]
[null,null,null,null,null,null,null,null,null,null,null,null,"[B4:G10].Select"]
[null,null,null,null,null,null,null,null,null,"Range(\"B4\", \"G10\").Select"]
[]
[null,null,null,null,null,null,null,null,null,"Range(Cells(4, 2), Cells(10, 7)).Select"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Range(\"B4\", \"G10\").Select"]
[null,null,null,null,null,null,null,null,null,"[B4:G10].Select"]
[]
[null,null,null,null,null,null,null,null,null,"Pozor více nesourodých oblastí"]
[]
[null,null,null,null,null,null,null,null,null,"Range(\"B4:G10,B13:E18, B24:C26\").Select"]
[]
[null,null,null,null,null,null,null,null,null,"Viz Union"]
[null,null,null,null,null,null,null,null,null,"Viz CurrentRegion"]
[]
[null,"Pojmenovaná oblast:",null,null,null,null,null,null,null,"Oblasti"]
[null,"MojeOblast"]
[null,null,null,null,null,null,null,null,null,"' Předpoklad že existuje pojmenovaná oblast"]
[null,null,null,null,null,null,null,null,null,"Range(\"MojeOlbast\").Select",null,null,"[MojeOlbast].Select"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Oblast v oblasti"]
[]
[null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,"' Co provede?"]
[2,null,null,null,null,null,null,null,null,"Range(\"B31:G34\").Cells(2, 3).Select"]
[3,null,null,null,null,null,null,null,null,"' Buňka v oblasti"]
[4]
[]
[]
[null,null,null,null,null,null,null,null,null,"Range(\"B31:G34\").Cells(2).Select"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Range(\"B31:G34\").Cells(8).Select"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Range(\"B31:G34\").Cells.Select"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Range(\"B31:G34\").Cells.Select"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Range(\"B31:G34\").Cells.Activate"]
[]
[]
[]
[null,"Úkol"]
[null,"Označit oblast na jiném listu využitím  Range(Cells(4, 2), Cells(10, 8)).Select"]
[]
[]
[]
[]
["Příklad k článku:"]
["http://office.lasakovi.com/excel/vba-listy-bunky/excel-vba-vybirat-oznacovat-bunky/"]
["Pavel Lasák 2017, rev 2021"]

{"sheet":"Jiné listy","index":5,"n_rows":92,"n_cols":6,"rows_kept":92,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[90,0,90,6],[91,0,92,4],[69,1,69,6],[81,1,81,6]]}
["Select   JINÉ LISTY   - Excel VBA"]
["http://office.lasakovi.com/"]
[]
[null,"Sheets","všechny listy"]
[null,"    Worksheets","listy s buňkami"]
[null,"    Chart","Listy s grafy"]
[]
[]
[null,null,null,null,null,"Apple"]
[null,"Jiný list - název listu"]
[]
[null,"Worksheets(\"List2\").Activate"]
[null,"' Vstoupim do listu"]
[null,"ActiveSheet.Range(\"B3\").Select"]
[]
[]
[null,"Sheets(\"List2\").Activate"]
[null,"ActiveSheet.Range(\"B3\").Select"]
[]
[]
[]
[null,"Jiný list - pořadové číslo listu"]
[]
[null,"Worksheets(2).Activate"]
[null,"ActiveSheet.Range(\"B3\").Select"]
[]
[]
[null,"Sheets(2).Activate"]
[null,"ActiveSheet.Range(\"B3\").Select"]
[]
[]
[]
[null,"Jiný list - kodové jméno listu"]
[]
[null,"' hodnota bunky"]
[null,"KodoveJmeno.Activate"]
[null,"ActiveSheet.Range(\"B3\").Select"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"' hodnota bunky"]
[null,"KodoveJmeno.Activate"]
[null,"ActiveSheet.[B3].Select"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Speciál"]
[]
[]
[null,"Další tip přes Goto"]
[]
[null,"Application.Goto ActiveWorkbook.Sheets(\"List2\").Cells(3, 2)"]
[]
[]
[null,"Tip přes Range?"]
[]
[null,"Tip k procvičení"]
[]
[null,"Úkol"]
[null,"Označit oblast na jiném listu využitím  Range(Cells(4, 2), Cells(10, 8)).Select"]
[null,"Bude se hodit v dalších kapitolách"]
[]
[null,"'  Řešení"]
[null,"' Jak označovat oblast na jiném listě využitím Range a Cells!"]
[null,"Sheets(\"List2\").Range(Sheets(\"List2\").Cells(4, 2), Sheets(\"List2\").Cells(10, 8)).Select"]
[null,"Viz kopírování kde využijeme"]
[]
[]
[null,"Tip viz kapitola \"Setování\""]
[]
[]
[]
[null,"Tip: "]
[null," hodnota bunky zobrazit"]
[null,"MsgBox (KodoveJmeno.[B11].Value)"]
[]
["Příklad k článku:"]
["http://office.lasakovi.com/excel/vba-listy-bunky/excel-vba-vybirat-oznacovat-bunky/"]
["Pavel Lasák 2017 rev 2019, 2020"]

{"sheet":"Speciálnosti","index":6,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,13,0,19],[1,13,1,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Select BUŇKA - Excel VBA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"http://office.lasakovi.com/"]
[]
[]
[null,null,null,null,"E5"]
[]
[null,"Range(\"E5\").Range(\"B3\").Select"]
[]
[]
[null,"Range(\"E5\").Range(\"A1\").Select"]
[null,"' Viz offset"]
[]
[]
[]
[]
[null,"Range(\"E5\", ActiveCell).Select"]
[null,"'Od buňky E5 do aktivní buňky"]
[]
[]
[]
[null,"Range(\"E5:G8\").Cells"]
[null,"' Redudantní nefunguje chyba"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Private Sub CommandButton8_Click()"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Range(\"A2:C4\").Cells(1).Select"]
[null,"Cells.Item(5, \"E\").Select"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"End Sub"]
[null,"Cells.Item(5,5).Select"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Private Sub CommandButton9_Click()"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Range(\"A2:C4\").Cells(6).Select"]
[]
[null,"MsgBox (Range(\"B4:G10\").Rows.Count)"]
[]
[]
[]
[]
[]
[null,"Range(\"A2:C4\").Cells(1).Select"]
[null,"' Vybrana A2"]
[]
[null,"Range(\"A2:C4\").Cells(6).Select"]
[null,"' Vybrana C3"]
[]
[null,"Range(\"A2:C4\").Cells(10).Select"]
[null,"' Vybrana A5 ... momo vybrnou oblast"]
[]
[null,"Range(\"A2:C4\").Cells(2,2).Select"]
[null,"' Vybrana C3"]
[]
[null,"Range(\"A2:C4\").Cells(4,5).Select"]
[null,"' Vybrana C3"]
[]
[null,"Range(\"A2:C4\").Cells(4, 5).Select"]
[null,"' Vybrana E5 mimo vybranou oblast"]

{"sheet":"Current Used","index":7,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,0,46,4],[0,0,0,8],[1,0,1,8],[4,1,4,7],[24,1,24,7],[2,0,2,8]]}
["CurrentRegion - UsedRange  - Excel VBA"]
["http://office.lasakovi.com/"]
["Viz samostatný sešit"]
[]
[null,"CurrentRegion"]
[]
[null,"Id","Jméno ","Příjmení"]
[null,1,"Pavel","Lasák"]
[null,2,"Iva","Malá"]
[null,3,"Eva","Velká"]
[]
[null,"Kód"]
[]
[null,"Range(\"B7\").CurrentRegion.Select"]
[null,"' Ctrl + A"]
[null,"' Pro výběr tabulky"]
[]
[null,"Tip Apple"]
[null,"ActiveSheet.Range(\"B7\").CurrentRegion.Select"]
[]
[]
[]
[]
[]
[null,"UsedRange"]
[]
[null,"Kód"]
[]
[null,"UsedRange.Select",null,null,null,null,null,null,null,null,null,";"]
[null,"' Ctrl + End"]
[]
[]
[null,"Tip Apple"]
[null,"ActiveSheet.UsedRange.Select"]
[]
[]
[]
[]
[null,"Poznámky"]
[null,"možnost speciálního výběru"]
[null,"https://office.lasakovi.com/excel/vba-listy-bunky/CurrentRegion-UsedRange-Excel-VBA/"]
[null,"změna velikost "]
[null,"atd."]
[]
[]
["Pavel Lasák 2017 rev 2019, 2020"]

{"sheet":"Řádky sloupce","index":8,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,1,3],[0,0,0,3]]}
["Select   řádky / sloupce   - Excel VBA"]
["http://office.lasakovi.com/"]
[]
[null,"Viz samnostatný sešit"]
[null,"Řádky"]
[]
[null,"' Vyber/označ řádek 9"]
[null,"Rows(9).select"]
[]
[]
[null,"' Vyber řádky 9 až 15"]
[null,"Rows(\"9:15\").Select"]
[]
[]
[null,"Rows(9).EntireRow.Select"]
[]
[]
[null,"Range(\"C9\").EntireRow.select"]
[]
[]
[null,"Rows(\"9:10\").EntireRow.Select"]
[]
[null,"viz samostatný sešit na práci s řádky a sloupci"]
[]
[]
[null,"Sloupce"]
[]
[null,"Columns(3).Select"]
[]
[]
[null,"Columns(\"D\").Select"]
[]
[]
[null,"Columns(\"D:E\").Select"]
[]
[]
[null,"' označí patý (\"E\") až desatý (\"J\") sloupec "]
[null,"Range(Cells(1,5),Cells(1,10)).EntireColumn.Select "]
[]
[null,"' Od páteho sloupce přes resize viz samostatná kapitola"]
[null,"' Viz další soubor pro posun a resize"]
[null,"Cells(1,5).Resize(,5).EntireColumn.Select "]
[]
[null,"Tip"]
[null,"Viz samostatný sešit práce řádky slouopce"]

{"sheet":"Formát dat","index":9,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Formát dat"]
["https://office.lasakovi.com/"]
[null,"Viz samnostatný sešit"]
[]
[]
[]
[null,null,"Obecný",null,"Obecný využitím ActiveCell"]
[null,null,"    Selection.NumberFormat = \"General\"",null,"ActiveCell.NumberFormat = \"General\""]
[null,null,"Číslo"]
[null,null,"    Selection.NumberFormat = \"0.00\""]
[null,null,"Měna"]
[null,null,"    Selection.NumberFormat = \"_($* #,##0.00_);_($* (#,##0.00);_($* \"\"-\"\"??_);_(@_)\""]
[null,null,"Účetnický"]
[null,null,"    Selection.NumberFormat = \"_($* #,##0.00_);_($* (#,##0.00);_($* \"\"-\"\"??_);_(@_)\""]
[]
[null,null,"Datum"]
[null,null,"    Selection.NumberFormat = \"m/d/yyyy\""]
[null,null,"Datum dlouhé"]
[null,null,"    Selection.NumberFormat = \"[$-x-sysdate]dddd, mmmm dd, yyyy\""]
[null,null,"čas"]
[null,null,"    Selection.NumberFormat = \"[$-x-systime]h:mm:ss AM/PM\""]
[null,null,"Procenta"]
[null,null,"    Selection.NumberFormat = \"0.00%\""]
[null,null,"Zlomek"]
[null,null,"    Selection.NumberFormat = \"# ?/?\""]
[]
[null,null,"Matematický"]
[null,null,"    Selection.NumberFormat = \"0.00E+00\""]
[null,null,"Text"]
[null,null,"    Selection.NumberFormat = \"@\""]
[]
[]
[]
[]
[null,"Tip"]
[null,"Viz samostatný sešit na formáty"]

{"sheet":"Ostatní tipy","index":10,"n_rows":68,"n_cols":6,"rows_kept":68,"cut":false,"hidden":false,"merged":[[33,0,33,2],[0,0,0,2],[1,0,1,2],[21,0,21,2],[22,0,22,2],[32,0,32,2]]}
["Která buňka(y) vybrány"]
["http://office.lasakovi.com/"]
[]
[]
[null,"Které buňky vybrány,"]
[null,"Dim Bunka As Range"]
[null,"For Each Bunka In Selection"]
[null,"    MsgBox \"Vybraný řádek je \" & Bunka.Row"]
[null,"    MsgBox \"Vybraný sloupec je \" & Bunka.Column"]
[null,"Next Bunka"]
[]
[]
[]
[]
[]
[]
[null,"Otázka"]
[null," co když označím dvě?"]
[]
[]
[]
["Jména listů"]
["http://office.lasakovi.com/"]
[]
[null,"' Tip vložit do procedury"]
[null,"Msgbox activesheet.name ‘Name of active sheet"]
[null," Msgbox activeworkbook.name ‘Name of active workbook"]
[null," Msgbox activecell.name ‘Name of active cell"]
[null," Msgbox thisworkbook.name ‘Name of workbook where this code is stored"]
[]
[]
[]
["Slučování oblastí"]
["http://office.lasakovi.com/"]
[]
[]
[]
[]
[null,"Test"]
[]
[]
[null,"Jmeno ","Prijmeni","Věk"]
[null,"Ema","Mala",10]
[null,"Iva","Velka",20]
[null,"Jan","Xxxx",30]
[null,"Eva","Yyyy",40]
[]
[]
[]
[]
[]
[]
[null,"Slučování oblastí"]
[]
[null,"Dim r1, r2, myMultipleRange As Range"]
[null,"Set r1 = Range(\"B50:C52\")"]
[null,"Set r2 = Range(\"F54:G55\")",null,null,null,"Slučování oblastí"]
[null,"Set myMultipleRange = Union(r1, r2)"]
[null,"myMultipleRange.Select"]
[]
[]
[null,"Včetně listu"]
[]
[null,"Dim r1, r2, myMultipleRange As Range "]
[null,"Set r1 = Sheets(\"Sheet1\").Range(\"B50:C52\") "]
[null,"Set r2 = Sheets(\"Sheet1\").Range(\"F54:G55\")"]
[null,"Set myMultipleRange = Union(r1, r2) "]
[null,"myMultipleRange.Select"]

{"sheet":"Sloucene","index":11,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,2,3,5],[5,1,9,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Range(\"C4\").Select"]
[null,null,null,null,null,null,null,null,null,null,"' Vybere C4:F4"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Range(\"C3:D5\").Select"]
[null,null,null,null,null,null,null,null,null,null,"' Vybere C3:F5"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Columns(\"D\").Select"]
[null,null,null,null,null,null,null,null,null,null,"' Vybere C:F"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Rows(\"7\").Select"]
[null,null,null,null,null,null,null,null,null,null,"' Vybere 6:10"]

{"sheet":"List3","index":12,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"Union(Range(\"B2:D4\"), Range(\"C3:F5\")).Select"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,35,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[]
[1,"A"]
[2,"B"]
[3,"C",null,null,null,null,null,null,null,null,null,null,null,"Id","Jméno ","Příjmení"]
[4,"D",null,null,null,null,null,null,null,null,null,null,null,1,"Pavel","Lasák"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Iva","Malá"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Eva","Velká"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"**"]
[null,"Úkol",null,null,null,null,null,null,null,null,null,null,null,null,null,"***"]
[null,"Procházej tabulku A1:B4"]
[null,"Vždy znač jednu buńku"]
[null,"Např A1 atd…"]
[]
[null,"Tip"]
[null,"Až budete umět načítat hodnoty z buněk tak zobrazte v MsgBOxu"]

{"sheet":"Pokusy","index":13,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,1,4,4],[0,0,0,5],[1,0,1,5]]}
["Select - Excel VBA"]
["http://office.lasakovi.com/"]
[]
[]
[null,"Uložit obsah do proměnné"]
[]
[]
[null,"Dim MojeOblast As Range"]
[null,"Set MojeOblast = Range(\"B4\")"]
[null,"MojeOblast.Select"]
[]
[]
[]
[null,"Tip"]
[null,"Až budete mít za sebou deklaraci proměných a setování"]