Creating An Array Based on Conditions from a Non-Contiguous Cells which are Sheet Names

Creating An Array Based on Conditions from a Non-Contiguous Cells which are Sheet Names

Dear Forum,

I need to create array to be used in an earlier Macro on a recent solution from CheeseSandwich... Replicating Sheet as Values but keeping only SUM Formula & Converting Other formulas-Values
https://www.excelforum.com/excel-pro...ml#post5819635

I need to create Array for the Old Sheet Name and the New Sheet Name based on the Macro Name..

Regards
e4excel

Try it like this:

Please Login or Register  to view this content.

Thanks Bernie, but I need the Single Column Array...for example Old Sheet Array and NEW Sheet Array separate. .your code is exactly what I want but can you make it in such a way that I select the TEST 1 and the Columns as parameter...
Its done after checking the code, i realized that its pretty simple...

Please Login or Register  to view this content.