IT-Academy

VBA odoslanie

Feb 21st, 2017
140
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.    
  11.     Cells(row, 1).Value = txtMeno.Value       '1 -> row
  12.   Cells(row, 2).Value = txtPriezvisko.Value
  13.     Cells(row, 3).Value = txtEmail.Value
Advertisement
Add Comment
Please, Sign In to add comment