Passing Range Names as Arguments

[joatm0n]

I have a number of named ranges in my workbook. I have a subroutine that I need to call repeatedly and need to pass one of these names as an argument to the subroutine. Here is my code right now:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

If it's not obvious, the idea is to work through a list of named ranges, sending each one individually to a subroutine called copyPaste. copyPaste first looks to another workbook (that will also contain a range with the exact same name), and copy the contents of that range onto the clipboard. Then it pastes these contents (as values) into the range in the active workbook. Conceptually pretty simple.

Right now, I am stuck passing the range name as an argument. I am getting a run-time error "Application defined or object defined error".

Can someone see what I am doing wrong?

Thanks!

[vandan_tanna]

I think if you add call keyword for the function call it will work ex:

Please Login or Register  to view this content.

or
remove the parenthesis for the arguments ex:

Please Login or Register  to view this content.

[joatm0n]

Thank you, but neither of these is the problem. I believe that this is a typing problem. I'm not able to match the type of the argument to the type of the parameter. I'm trying to pass these as a Range type, but what I am doing is not working. Not sure if I need to choose a different type or change the way that I am capturing/passing.

Anyone else see what is wrong?

[vandan_tanna]

That is interesting joatmOn. your code worked fine for me after the changes I posted above. Can you upload your file?

[JosephP]

the first line of the called routine should be

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

since thisRange is a specific Range object and not the name of one. you do also need to either use Call or remove the parentheses when calling the routine.