Paste Special Macro issue or macro look up issue

I need some assistance with a problem that I am having with my macro in Excel 2007.

I am combining two workbooks into one workbook. My Inventory Routing Guide tab does a lookup to the Master File Data tab and pulls that information into the tab. The problem that I am having is that the lookup function pulls across the information fine when there is not a formula in the cell. However, when there is a formula in the cell it inputs the information as “N/A”. I decided to a Paste Special for my Master File Data tab, but I still receive the same “N/A”.

The issue is with my MIN/MAX Button 2 macro.


I have attached my code and sample files for your review. Am I using an incorrect Paste Special command in my coding or is there a better way to get my information.

I apologize in advance, but I had to zip my Inventory Routing Guide because it is a .csv file.

Here is my code for the paste special

Please Login or Register  to view this content.

Here is my code for my lookup.

Please Login or Register  to view this content.

I have updated my macro above to possibly help provide some additional feedback. I have modified the .csv file that I normally import to a .xls file. I have modified the entry screen to accept the file as an .xls file. I hope this alleviate any concerns that my original post may have caused.

Please let me know if you need any additional information.