Home |
Search |
Today's Posts |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 ranges into one
David wrote
Is there some code I can add to put the checkmark into the corresponding cell in the "Attendance" sheet at the same time? That would eliminate the need for CopyToday(). Yipee!! Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error Resume Next If Intersect(Target, [a3:a93]) Is Nothing Then Exit Sub With Selection.Offset(0, Rows(2).Find(Date).Column - 1) .Value = Chr(252): .Font.Name = "Wingdings" End With Set srcaddress = Selection.Offset(0, Rows(2).Find(Date).Column - 1) srcaddress.Copy Destination:=Sheets(3).Range(srcaddress.Address) End Sub -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how copy formula that contains ranges so ranges do not overlap | Excel Worksheet Functions | |||
HELP ON AGE RANGES | Excel Worksheet Functions | |||
Looking in Ranges | Excel Discussion (Misc queries) | |||
Sum the ranges | Excel Worksheet Functions | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) |