Advertisement
Guest User

Untitled

a guest
Nov 17th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. dim valeur as range
  2.  
  3. For Each valeur In ThisWorkbook.Worksheets(1).Range("A1:A" & ThisWorkbook.Worksheets(1).Range("A1").End(xlDown).Row)
  4.     ThisWorkbook.Worksheets(1).Protection.AllowEditRanges.Add("T" & valeur.row ,"B" & valeur.row & ":AA" & valeur.row, "Test")
  5. Next valeur
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement