{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Timeseddel","T","Setup","Vejledning","Ark3","Ark1"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Timeseddel","index":0,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,0,49,1],[46,7,46,9],[47,7,47,9],[41,5,41,6],[42,5,42,6],[41,7,41,9],[42,7,42,9],[43,7,43,9],[44,7,44,9],[45,7,45,9],[43,5,43,6],[44,5,44,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[49,5,49,6],[36,7,36,9],[37,7,37,9],[38,7,38,9],[39,7,39,9],[40,7,40,9],[31,7,31,9],[32,7,32,9],[33,7,33,9],[34,7,34,9],[35,7,35,9],[27,7,27,9],[28,7,28,9],[29,7,29,9],[30,7,30,9],[29,5,29,6],[30,5,30,6],[7,0,7,3],[1,0,1,2],[3,1,3,3],[5,1,5,3],[26,7,26,9],[23,7,23,9],[24,7,24,9],[25,7,25,9],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[13,5,13,6],[15,5,15,6],[20,7,20,9],[21,7,21,9],[22,7,22,9],[16,8,16,9],[18,7,18,9],[19,7,19,9],[17,7,17,9],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,7,13,9],[14,7,14,9],[17,5,17,6],[18,5,18,6],[19,5,19,6],[14,5,14,6],[40,5,40,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[5,5,5,9],[36,5,36,6],[37,5,37,6],[38,5,38,6],[39,5,39,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[8,7,8,9],[15,7,15,9],[9,7,9,9],[10,7,10,9],[11,7,11,9],[12,7,12,9]]}
[]
[]
[]
["Cpr-nr. : ",null,null,null,null,"År:",2024,"Måned: ","April",{"$f":"IF(I4=\"Januar\",1,IF(I4=\"Februar\",2,IF(I4=\"Marts\",3,IF(I4=\"April\",4,IF(I4=\"Maj\",5,IF(I4=\"Juni\",6,IF(I4=\"Juli\",7,IF(I4=\"August\",8,IF(I4=\"September\",9,IF(I4=\"Oktober\",10,IF(I4=\"November\",11,IF(I4=\"December\",12,\"\"))))))))))))","v":4}]
[]
["Navn : ","Dit navn",null,null,null,"Ved gentaget tjeneste samme dag, skrives i bemærkninger "]
[]
["Regulering til sidste måned"]
["Dato","Dag","Timer","Overtid\n3210\nEfter kl. 17","Overtid\n3230\nWeekend","\nkm",null,"Bemærkninger"]
[null,{"$f":"IF(A10=\"\",\"\",IFERROR(CHOOSE(WEEKDAY(A10,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\"))","v":""}]
[null,{"$f":"IF(A11=\"\",\"\",IFERROR(CHOOSE(WEEKDAY(A11,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\"))","v":""}]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A15=\"\",\"\",IFERROR(CHOOSE(WEEKDAY(A15,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\"))","v":""}]
["Dato","Dag","Timer","Overtid\n3210\nEfter kl. 17","Overtid\n3230\nWeekend","km",null,"Bemærkninger"]
[]
[{"$f":"DATE(G4,J4,T!J1)","v":"2024-04-11"},{"$f":"IFERROR(CHOOSE(WEEKDAY(A18,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\")","v":"To"}]
[{"$f":"A18+1","v":"2024-04-12"},{"$f":"IFERROR(CHOOSE(WEEKDAY(A19,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\")","v":"Fr"}]
[{"$f":"A19+1","v":"2024-04-13"},{"$f":"IFERROR(CHOOSE(WEEKDAY(A20,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\")","v":"Lø"}]
["2024-04-14","Sø"]
["2024-04-15","Ma"]
["2024-04-16","Ti"]
["2024-04-17","On"]
[{"$f":"A24+1","v":"2024-04-18"},"To"]
["2024-04-19","Fr"]
["2024-04-20","Lø"]
["2024-04-21","Sø"]
["2024-04-22","Ma"]
["2024-04-23","Ti"]
["2024-04-24","On"]
["2024-04-25","To"]
["2024-04-26","Fr"]
["2024-04-27","Lø"]
["2024-04-28","Sø"]
["2024-04-29","Ma"]
["2024-04-30","Ti"]
["2024-05-01","On"]
["2024-05-02","To"]
["2024-05-03","Fr"]
["2024-05-04","Lø"]
["2024-05-05","Sø"]
["2024-05-06","Ma"]
["2024-05-07","Ti"]
["2024-05-08","On"]
[{"$f":"IFERROR(IF(DAY($A$18)<>1,IF(DAY(A45+1)>=T!$J$1,\"\",A45+1),IF(MONTH(A45+1)>MONTH(A45),\"\",A45+1)),\"\")","v":"2024-05-09"},"To"]
[{"$f":"IFERROR(IF(DAY($A$18)<>1,IF(DAY(A46+1)>=T!$J$1,\"\",A46+1),IF(MONTH(A46+1)>MONTH(A46),\"\",A46+1)),\"\")","v":"2024-05-10"},"Fr"]
[{"$f":"IFERROR(IF(DAY($A$18)<>1,IF(DAY(A47+1)>=T!$J$1,\"\",A47+1),IF(MONTH(A47+1)>MONTH(A47),\"\",A47+1)),\"\")","v":""},""]
[]
["Timer i alt : ",null,{"$f":"SUM(C10:C48)","v":0},{"$f":"SUM(D10:D48)","v":0},{"$f":"SUM(E10:E48)","v":0},{"$f":"SUM(G10:G48)","v":0}]

{"sheet":"T","index":1,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,3,0,4],[0,0,0,1]]}
[null,null,null,"Norm",null,null,"Kirke",null,"Perioden start dato : ",11]
["Januar",1,null,"Mandag",7,null,"Allinge"]
["Februar",2,null,"Tirsdag",8,null,"Olsker"]
["Marts",3,null,"Onsdag",8,null,"Tejn"]
["April",4,null,"Torsdag",8,null,"Rutsker"]
["Maj",5,null,"Fredag",6,null,"Hasle"]
["Juni",6,null,"Lørdag",0,null,"Rø"]
["Juli",7,null,"Søndag",0,null,"Gudhjem"]
["August",8,null,null,{"$f":"SUM(E2:E8)","v":37},null,"Østerlars"]
["September",9,null,null,null,null,"Østermarie"]
["Oktober",10,null,null,null,null,"Svaneke"]
["November",11,null,null,null,null,"Ibsker"]
["December",12,null,null,null,null,"Nexø"]
[null,null,null,null,null,null,"Poulsker"]
[null,null,null,null,null,null,"Pedersker"]
[null,null,null,null,null,null,"Bodilsker"]
[null,null,null,null,null,null,"Aakirkeby"]
[null,null,null,null,null,null,"Vestermarie"]
[null,null,null,null,null,null,"Nyker"]
[null,null,null,null,null,null,"Nylars"]
[null,null,null,null,null,null,"Knudsker"]
[null,null,null,null,null,null,"Rønne"]
[null,null,null,null,null,null,"Christians Ø"]

{"sheet":"Setup","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,3,0,4],[8,0,9,0]]}
["Til","laptop@outlook.dk","B1"]
["Cc",null,"B2"]
["Bcc",null,"B3"]
["Emne linjen",{"$f":"\"Timeseddel - \"&Timeseddel!B6&\" - År : \"&Timeseddel!G4&\" - Måned : \"&Timeseddel!I4","v":"Timeseddel - Dit navn - År : 2024 - Måned : April"},"B4"]
["Lagrings Mappe sti","C:\\","B5"]
["PDF gemme navn",{"$f":"IF(Timeseddel!J4>9,Timeseddel!B6&\" - \"&\"Timeseddel - \"&Timeseddel!G4&\" - \"&Timeseddel!J4&\" - \"&Timeseddel!I4,Timeseddel!B6&\" - \"&\"Timeseddel - \"&Timeseddel!G4&\" - 0\"&Timeseddel!J4&\" - \"&Timeseddel!I4)","v":"Dit navn - Timeseddel - 2024 - 04 - April"},"B6"]
[null,null,"B7"]
[null,null,"B8"]
[]
[]
[]
["Mail tekst","Hej Regnskabsfører.\r\n\r\nJeg sender hermed min Timeseddel for september.\r\n\r\nMed venlig hilsen\r\n\r\n\r\n\r\n","B12"]

{"sheet":"Vejledning","index":3,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Bruger vejledning til Timeseddel"]
[null,"Gem Og Send timeseddel som PDF"]
[null,"Denne knap bruges når man har udfyldt den sidste dag i måneden,"]
[null,"så gemmer den timesedlen som en PDF-fil og Sender den til regnskabsføreren."]
[null,"Udskriv Timesedlen"]
[null,"Denne knap udskriver timesedlen på printeren."]
[null,"Skift mail-modtager og mail-besked"]
[null,"Ved at bruge denne knap kan du ændre den mail som timesedlen vil blive sendt til"]
[null,"Man kan også skrive den tekst der skal stå i mailen"]
[null,"så behøver man kun at lave det en gang."]
[null,"Gem og Luk"]
[null,"Denne knap bruges når man løbende indtaster timerne - den gemmer og lukker arket."]
[null,"Skift Lagringsmappe"]
[null,"Med denne knap kan man bestemme hvor den skal gemme timesedlen så man har den til en anden gang."]
[null,"Åben Lagringsmappen"]
[null,"Med denne knap kan man åbne den mappe hvor man har gemt sine timesedler."]
[null,"Opret PDF"]
[null,"Ved at klikke på denne knap opretter man en PDF-fil af timesedlen."]
[null,"Slet Data"]
[null,"Sletter data på arket så det er klat til en ny måned."]
[]
[null,"Man vælger periodens start dato på fanen \"T\""]

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

{"sheet":"Ark1","index":5,"n_rows":53,"n_cols":1,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["Clear Cells in Excel of a range or Worksheet using VBA- Solution(s):"]
[]
["We can clear Cells or a Range using Clear Method OR ClearContents Method of a Range or Cell. Clear will Clear the data and Formats of the given Range or Cells. And ClearContents will clear only the data, will not clear any formats."]
[]
["Clear Cells Range data in Excel Worksheet using VBA – An Example"]
[]
["The following examples will show you how clear the data of Cells, Range or entire worksheet using Clear and ClearContents Methods."]
[]
["Clearing a Cells/Range using Clear Method"]
[]
["This method will clear the range of cells including Formats:"]
[]
["Sub sbClearCells()"]
["Range(\"A1:C10\").Clear"]
["End Sub"]
[]
["Clearing Only Data of a Range using ClearContents Method"]
[]
["This method will clear only clear the content or data of the range not formats (Formats remain same)"]
[]
["Sub sbClearCellsOnlyData()"]
["Range(\"A1:C10\").ClearContents"]
["End Sub"]
[]
["Clearing Entire Worksheet using Clear Method"]
[]
["This method will clear entire worksheet including formats."]
[]
["Sub sbClearEntireSheet()"]
["Sheets(\"SheetName\").Cells.Clear"]
["End Sub"]
[]
["Clearing Only Data from Worksheet using ClearContents Method"]
[]
["This method will clear only data of worksheet, not formats."]
[]
["Sub sbClearEntireSheetOnlyData()"]
["Sheets(\"SheetName\").Cells.ClearContents"]
["End Sub"]
[]
["Instructions:"]
[]
["1. Open an excel workbook"]
["2. Enter some data in Sheet1 at A1:C10"]
["3. Press Alt+F11 to open VBA Editor"]
["4. Insert a Module for Insert Menu"]
["5. Copy the above code and Paste in the code window"]
["6. Save the file as macro enabled workbook"]
["7. Press F5 to run it"]
[]
["Conclusion:"]
[]
["Both Clear and ClearContents are useful based on your requirement. If you want to Clear only the Content, use ClearContent method. If you want Clear everything (Content and Formats), use Clear method."]