Advertisement
Guest User

Untitled

a guest
May 22nd, 2019
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. If USERFORMANTWOORD = "A" Then 'kiest welke categorie
  2. categorienummer = "1"
  3. ElseIf USERFORMANTWOORD = "B" Then
  4. categorienummer = "24"
  5. ElseIf USERFORMANTWOORD = "C" Then
  6. categorienummer = "47"
  7.  
  8.  
  9. testnummer = Range("A" & categorienummer).End(xlDown).Offset(1, 0).Row 'gaat naar onderste rij
  10. Rows(testnummer).Insert
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement