How to keep array list outside form macro module

[nur2544]

Dear all, I want to keep the array list outside the macro module , I mean there will be no array list inside the macro module , except this I want to keep the array list in an excel sheet (say , sheet name “input”) start form the range A2:A65536. I need your assistance regarding this. Here is the array list.

Please Login or Register  to view this content.

Here is macro example

Please Login or Register  to view this content.

why it is required ? as i am having a very big array list , & it is not possible to keep the list inside the macro module.

[:) Sixthsense :)]

Try this way...

Please Login or Register  to view this content.

[nur2544]

Hi Sixthsense , thanks for replay , would you please merge your code with my below code as I have tried to do that but failed .

Please Login or Register  to view this content.

[:) Sixthsense :)]

Change this to your desired sheet/Range

Please Login or Register  to view this content.

[nur2544]

Hi Sixthsense,
Its really outstanding job that you have done for me , I was trying to solve my issue for many days but failed , now I got my solution , & I am very much happy with you. Thanks for your great support to me which makes my job easier . stay safe all time …

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback and rep

But,

Oopss... Just delete the below line from the Post #4 code because I forgot to delete it when posting and which is just lying as a junk which is not needed for the code.

Please Login or Register  to view this content.

[nur2544]

No issue , I already did it , thanks again.