I have searched and come across the code below that looks like it will accomplish what I am looking for. I need help to modify and complete this for my work book. Here is what I need; My workbook has several worksheets that are identical(T-0, T-2, T-4, T-6), each has a range BI10:BO11 that are linked to a resource calendar. Six weeks out I would run a Macro that loads work tasks into worksheet T-6. The links listed above contain the resourse hours available at that time. I need to replace the links with the values they are displaying on the T-6 work sheet. This would be repeated two weeks later when tasks are loaded into T-4 work sheet and so on. The code I found below seems like it would work but I am not sure how to enter the specific range BI10:BO11, also only run this on the active worksheet so the cells in other worksheets are not affected. I was not able to open the sample file to see how this was modified when i located in a search. Hope someone can help out with this
Code:
Sub Paste_Value()
Dim r As Range
For Each r In Selection
r.Formula = r.Value
Next r
End Sub