EXCEL - Running a macro on Excel 2007?

[bloodline76]

I was wondering if anyone can help me run a marco on an excel workbook. I have the macro but I dont know how to apply it to the data. When I try I get the following error:

Runtime error 9

Subscript out of range

Thanks!