IT-Academy

Ukladanie Excel

Jan 28th, 2018
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.     Dim row As Integer
  2.     Range("A1").Select
  3.     row = 1
  4.    
  5.     Do Until ActiveCell = ""
  6.         ActiveCell.Offset(1, 0).Activate
  7.         row = row + 1
  8.     Loop
  9.    
  10.     'Hárok29.Unprotect
  11.    Cells(row, 1).Value = txt_Meno.Value       '1 -> row
  12.    Cells(row, 2).Value = txt_Priezvisko.Value
  13.     Cells(row, 3).Value = txt_Email.Value
  14.     'Hárok29.Protect
Advertisement
Add Comment
Please, Sign In to add comment