Hi guys, I'm having problems with the record Macro in Excel 2007. If I use the same marco in a different row, cell or column after saving data in a Workbook & worksheets, one of three things happens: Visual basic editor in Excel complains that a single line of code is too long, or that the "agruments is invalid", or a "method or object not supported".

I use to run the some code on a old version of excel (2002-2003) without any problems. After updating to Office 2007 the code doesn't work, or doesn't complete runtime.

I have tried update manager and reading FAQ, but I don't see why the old code is that out of date that Excel couldn't fix the problem without incurring errors.