{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Blad1","Blad2"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Blad1","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,6,5,7],[9,2,20,8]]}
[]
[]
[]
[]
[null,null,null,"Variabel",4]
[null,null,null,null,null,null,"Waarden uit Blad2"]
[null,null,null,null,null,null,"Kolom C","Kolom E"]
[null,null,null,"Regel nr.",{"$f":"MATCH(E5,Blad2!A9:A18,0)","v":4},null,"Eieren","Scharrel"]
[]
[null,null,"Als de waarde in cel E5 wordt geweizigd moet de Regel nr. ook wijzigen, dat gebeurd ook.\nMaar hoe krijg ik de waarden uit de kolommen C en E naar de 2 cellen gekopieerd d.m.v. VBA zonder naar het tabblad Blad2 heen en weer te switchen? Normaal lukt dat wel maar omdat de regel variabel is krijg ik dit niet in een VBA code.\n\nWie heeft voor mij een oplossing?\nB.v.d. Cor Assa"]

{"sheet":"Blad2","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[1,null,"Kip",null,"Scharrel"]
[2,null,"Vis",null,"Zee"]
[3,null,"Bloemkool"]
[4,null,"Eieren",null,"Scharrel"]
[5,null,"Bloemen",null,"Sier"]
[6,null,"Bami",null,"Indonesisch"]
[7,null,"sate",null,"Indonesisch"]
[8,null,"Mozarella",null,"Italie"]
[9,null,"Water",null,"Mineraal"]
[10,null,"Sap",null,"Appel"]