LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 195
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how copy formula that contains ranges so ranges do not overlap Patty Excel Worksheet Functions 1 November 20th 08 04:15 PM
HELP ON AGE RANGES Malcolm Austin Excel Worksheet Functions 4 July 31st 07 09:52 AM
Looking in Ranges [email protected] Excel Discussion (Misc queries) 1 April 18th 07 04:24 PM
Sum the ranges Andri Excel Worksheet Functions 5 March 24th 07 04:36 PM
Like 123, allow named ranges, and print named ranges WP Excel Discussion (Misc queries) 1 April 8th 05 06:07 PM


All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"