Using cell value to open fill and paste into

[khalid79m]

Please Login or Register  to view this content.

Hi I need help with this code It is supposed to: look in column IV and using the cell values filter in column 17. then it supposed to select Current Region A1 and copy it which it does, then it supposed open a file using the cell value in iV for which it has filtered for which it does, then it is supposed to select FileData sheet on that file it has opened and select range a1 which it does, then it is supposed to paste the data which it doesnt. I have followed it set by step. When I open the file using the cell value in IV for which it has filtered it loses the info on the clipboard ( the pasted info) can anyone help !¬!!!

error message

Paste Method of Worksheet Class Failed