Hi all,
I've been having trouble figuring out how to do this.
What I want to do is something like this:
I've tried to run and change this code, but Excel will crash every time.Private Sub Worksheet_Change(ByVal Target As Range) Dim circNumber As Range, c As Range Dim rowNum As Integer Set circNum = Range("A32:A55") rowNum = ActiveCell.Row - 32 If Range("U11").Value = "8" And Range("U14").Value = "IP" Then For Each c In circNum c.Validation.Delete c.Value = rowNum & "/1" Next c End If End Sub
I'm not familiar enough with VBA to figure out why. Any help?
Thanks!
Bookmarks