msfz751

Untitled

Jan 2nd, 2014
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2.   If Intersect(Target, Range(Cells(2, 2), Cells(2, 2).End(xlDown).End(xlToRight))) Is Nothing Then Exit Sub
  3.   Dim cell As Range
  4.   If aCon.State = adStateClosed Then Connect
  5.   For Each cell In Intersect(Target, Range(Cells(2, 2), Cells(2, 2).End(xlDown).End(xlToRight)))
  6.     With aCmd(cell.Column - 1)
  7.       .Parameters(0) = cell(, -cell.Column + 2)
  8.       .Parameters(1) = cell
  9.       .Execute , , adExecuteNoRecords
  10.     End With
  11.   Next
  12. End Sub
Advertisement
Add Comment
Please, Sign In to add comment