Writing a Macro in Excel 2007

Would like to edit data below so that the first $ sign is removed from the formula in the first cell, then moving to right it is removed in the 2nd cell, etc. When the end of the first row is reached, the macro should drop down to the next row and repeat the operation until there are no more rows. Is this within the capability of Excel?

….. Col A…Col B…Col C…Col D…Col E
Row 1 =$C$8 =$D$8 =$F$8 …… =$H$8
Row 2 =$C$9 =$D$9 =$F$9 …… =$H$9