Very confused "subscript of Range"

[Johnny2times]

I am trying to create a small macro that will prompt the user to select a .xls file and import data from that file and fill the "Master"

I am not having any problems populating the first sheet but when I try to move to the next sheet on the "Master" it gives me error not sure why?

Please Login or Register  to view this content.

Any advice would be much appreciated

[JapanDave]

You have hard coded the sheet values and that will give you this error.

Post a sample workbook.