Excel Spreadsheet Macro Question
Posted on 2002-04-05
I have a Macro that copies range I9:I22 from each sheet and pastes it to a summary sheet. The macro works great but when i go back to each sheet where the macro selected that range those cells are still black or selected. How do you write code into my macro to Unselect or unblacken those cells on each sheet?
Here is a copy of my macro.....
Application.ScreenUpdating = False
Dim timesheet As Worksheet
Dim Cell As Range
For Each timesheet In ActiveWorkbook.Worksheets
ActiveCell.Offset(0, 1).PasteSpecial Paste:=xlValues
Application.CutCopyMode = False