8 Line Code Works On Other Computer, Not Mine

Please Login or Register  to view this content.

This code looks through the table "CF_Feb" and replaces any blank cells with the value above. In theory. Someone helped me put this together and it works for them, but not me. I am running Excel 2010. I'm not sure what they have but could find out. When I try to run this it says
"Run-Time error '1004':
Application-defined or object defined error"

Any ideas here?

*edited. Thanks Fotis, I've added the code tags. I know this breaks rule 6a, but I hope it's alright

Originally Posted by Relmiw

Please Login or Register  to view this content.

This code looks through the table "CF_Feb" ....

I think your code is searching for a range named "CF_Feb[Item]" and not "CF_Feb" . Take '[Item]' out from your code.