I've been trying to figure out a VBA that will Loop through a range of Cells in A1:A37 which contains various Dates. I'm trying to check if the date is Less than or equal to the current date. If it is, then the Cell next to in Column B which contains a formula producing a number will remove the formula and replace with Value calculated. Any Help will be appreciated.

Ex:

A | B |

7/28/2013 | "Formula" |

7/30/2013 | "Formula" |

<TBODY>

</TBODY>

A | B |

7/28/2013 | "Value" |

7/30/2013 | "Formula" |

<TBODY>

</TBODY>