[Chad Holden]

http://webomania.wordpress.com/2006/10/01/out-of-range-value-adjusted-for-column-error/ <- this is actually the solution right here. I dont know how it works, but it fixed my problem completely.