Define only 2 named ranges from a list of named ranges...

Hi,
I have written this macro to convert into a csv file to run for all defined named ranges in the activesheet. It run jst perfect when I hit SAVE button and it creates that many different CSV files for each named range.

However I am trying to use same macro in the another file and the problem I am facing is there a lot more named ranges and I want to run the macro for only selected NAMED RANGE. In this case 2 Named Range / 24 Named range.

Can you advise on what part of code do I need to change and to what to make it work for jst 2 named ranges ?

Please Login or Register  to view this content.

I want to run for NAMED RANGE - CMMDTY and BUSGROUP only.

please advise

Hi,

thanks for the update, however I am now getting an error as "Select method of range class failed."


getting error on this line :-

Please Login or Register  to view this content.

Is it due to the fact that I have the named ranges in 2 different sheets and not all of them in active worksheet ?

But then I thought the macro should still work irrespective but alas !!

I have this code under MODULE 1 and Under THISWORKBOOK I have the Call function as :

Please Login or Register  to view this content.

Fantastic IT worked..!!

Hi,
as per the code above I am jst wondering if the file gets saved to my local or specified drive location as well as to the location that i mentioned in the macro.

I know that the csv files gets saved in the location mentioned in the macro.. however how do I know if the file has been saved to my local drive as well or if I want to specify SAVE AS to a different location then will it run macro again ? and wont it will ask me to overwrite the existing CSV files again and again ?

sorry but did I confuse it even more ?

please advise