marcro triggering #N/A in cells

[Kezwick]

Hey sorry me again i no i no i need to go on a course or something:P
i have a macro (will copy in) that opens a file and then says this cell value = another (ull see)
neway it keeps returning #N/A in some cells i have checked the macro and the right cells are selected i also cheked the sourse file and there is data in the cellso im confused,

Please Login or Register  to view this content.

is there something here im doing wrong
Many thanks

[Kezwick]

problem solved i changed it to each line as only the same colunms seeped to work ok