Excel 2007 :: VBA To Replace Formulas In Certain Cells With Their Values?

I am running Microsoft Excel 2007 on Windows XP. Right now, I have the standard macro set up that will replace formulas with their values. It's the standard macro that does this for the entire sheet:

Code:
Sub All_Cells_In_Active_WorkSheet_1()
With ActiveSheet.UsedRange
.Cells.Copy
.Cells.PasteSpecial xlPasteValues
.Cells(1).Select
End With
Application.CutCopyMode = False
End Sub

However, with this being a daily task, the issue is that this wipes the formulas out for future dates, which is obviously problematic. To be more specific:

I have one tab (HISTORICAL) with over 200 rows with each business day this year. Columns B through H will pull data from two other tabs (ENTRY1 and ENTRY2) that is entered daily, using a formula that tells Excel to only pull the data for the current date:

Code:
=IF(A224=ENTRY1!B1,ENTRY1!B2,0)

So each day, someone will open this sheet and input their data on the ENTRY1 and ENTRY2 tabs. These numbers will auto populate over to the HISTORICAL tab for that specific day.

Also on each day, someone else will open the sheet and go to the HISTORICAL tab and run the macro that converts the formulas on that sheet to the value.

I want to be able to run the macro only for the row with the current date (and any date before will be fine since those will already be converted anyway).

So, taking today for example, when I run the macro, I want it to convert the data only in the 11/8/2011 and previous rows, but NOT for the 11/9/2011 and later rows.