Date Picker

[wsautrey]

How can I modify the following code to apply to a cell range rather that the active cell. Using Date Picker control in Excel 2010. Say Range AZ69:AZ77
as well as cell V32 and W44


Private Sub DTPicker21_Change()
ActiveCell.Value = DTPicker1.Value
End Sub

 

[OfficeUser]

How about:

Private Sub DTPicker21_Change()
Range("AZ69:AZ77, V32, W34") = DTPicker1.Value
End Sub