Import Multiple Ranges From Closed Workbook

Posted before and got great help...hope someone can come through for me again...

Have some VBA code that imports a selection from a closed workbook. Works great...I highlight my range in my current workbook, hit the macro button, and it imports the selected range from a closed workbook into my current workbook.

I am basically trying to apply the same principle in a new application, however instead of importing a selection, I want to import multiple ranges (they are always the same) from a closed workbook into my workbook.

I have tried every way I know how to modify the code to do this (but I'm a beginner). Gave up after trying and searching different posts. Can't seem to get it right.

Instead of selecting a range, I want to import these ranges when I run the macro (H39:N41, H48:N50, H54:N56)

Can someone help me make the changes I need to make to the code..

Please Login or Register  to view this content.