Cannot include copy paste in Macro

Hello,
I'm running Excel 2010 on a Windows 7 machine
I'm trying to create a macro and in this macro it include a copy paste of a formula I have made

It look like this in the macro

Please Login or Register  to view this content.

it works

but now, I have created a new sheet in my Excel doc called Reserved PCs and I want to use it

in Excel it looks like this and it works:

=IF(C2='Reserved PCs'!$A$2,'Reserved PCs'!$B$2,IF(C2='Reserved PCs'!$A$3,'Reserved PCs'!$B$3,IF(C2='Reserved PCs'!$A$4,'Reserved PCs'!$B$4,IF(C2='Reserved PCs'!$A$5,'Reserved PCs'!$B$5,IF(C2='Reserved PCs'!$A$6,'Reserved PCs'!$B$6,IF(C2='Reserved PCs'!$A$7,'Reserved PCs'!$B$7,IF(C2='Reserved PCs'!$A$8,'Reserved PCs'!$B$8,IF(C2='Reserved PCs'!$A$9,'Reserved PCs'!$B$9,IF(C2='Reserved PCs'!$A$10,'Reserved PCs'!$B$10,IF(C2='Reserved PCs'!$A$11,'Reserved PCs'!$B$11,IF(C2='Reserved PCs'!$A$12,'Reserved PCs'!$B$12,IF(C2='Reserved PCs'!$A$13,'Reserved PCs'!$B$13,IF(C2='Reserved PCs'!$A$14,'Reserved PCs'!$B$14,IF(C2='Reserved PCs'!$A$15,'Reserved PCs'!$B$15,IF(C2='Reserved PCs'!$A$16,'Reserved PCs'!$B$16,IF(C2='Reserved PCs'!$A$17,'Reserved PCs'!$B$17,IF(C2='Reserved PCs'!$A$18,'Reserved PCs'!$B$18,IF(C2='Reserved PCs'!$A$19,'Reserved PCs'!$B$19,IF(C2='Reserved PCs'!$A$20,'Reserved PCs'!$B$20,IF(C2='Reserved PCs'!$A$21,'Reserved PCs'!$B$21,IF(C2='Reserved PCs'!$A$22,'Reserved PCs'!$B$22,IF(C2='Reserved PCs'!$A$23,'Reserved PCs'!$B$23,IF(C2='Reserved PCs'!$A$24,'Reserved PCs'!$B$24,IF(C2='Reserved PCs'!$A$25,'Reserved PCs'!$B$25,IF(C2='Reserved PCs'!$A$26,'Reserved PCs'!$B$26,IF(C2='Reserved PCs'!$A$27,'Reserved PCs'!$B$27,IF(C2='Reserved PCs'!$A$28,'Reserved PCs'!$B$29,IF(C2='Reserved PCs'!$A$29,'Reserved PCs'!$B$30,IF(C2='Reserved PCs'!$A$31,'Reserved PCs'!$B$31,"")))))))))))))))))))))))))))))

In the macro it looks like this:

Please Login or Register  to view this content.

and if I run the macro, I got an error message (1004) --> Application defined or object defined error and the debug is pointing the formula as the problem

Can you please let me know what could be wrong there?

Moderator Note:

Pls use code tags around your code next time as per forum rules.


Thanks

Perhaps a simpler lookup formula to start with:

=VLOOKUP(C2, 'Reserved PCs'!$A:$B, 2, 0)

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.