InputBox to select named range and then SaveAs

[grizzly11]

Hi,

I'm using the following code to copy worksheets based on the contents of named ranges into a new workbook where the named range is entered into an InputBox.
The first part of the procedure works fine but when it gets to the SaveAs line it throws up run-time error 1004. I can get it to work by manually entering the file name but I would like the file to be saved as the name of the range ie. myRange.

Any help is appreciated.

Please Login or Register  to view this content.

[grizzly11]

I should have noted that the named ranges are actually dynamic. eg. =OFFSET(List!$N$1,1,0,MATCH("*",List!$N:$N,-1)-1)

I just discovered that if I change the ranges from dynamic to normal ie =List!$N$2:$N$15 then the previously posted code works.

Does anyone know how to deal with dynamic named ranges in this instance?

Many thanks

[mikerickson]

is myRange a named range (visible in the Name Manager) or is that just the VB variable that you use to receive the user input?

[grizzly11]

Hi Mike,

myRange is a variable where the user enters the actual range name via the InputBox.