Guest User

VBA

a guest
Nov 14th, 2018
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. Sub test()
  2.  
  3. Dim rng As Range
  4. Dim sht As Worksheet
  5. Dim Lastrow As Long
  6.  
  7. Set sht = ThisWorkbook.Sheets("Sheet1")
  8. Lastrow = sht.Cells(sht.Rows.Count, "A").End(xlUp).Row
  9.  
  10.  
  11. Set rng = Range("H2:H" & Lastrow)
  12. rng.Formula = "=TEXT(F2,("MMM-dd"))"
  13.  
  14. End Sub
Add Comment
Please, Sign In to add comment