Save dynamic ranges into Global array and return combined ranges

**Fishtail** · 02-22-2023, 09:51 PM

Hi VBA geniuses

I have a table with data that i am filtering with the (=FILTER) function.

Each time I have applied a filter ("A4 & "A6") I would like to save that range in a Global Array, and change the filter accordingly with a different setting for a new range to save.
Once I am done with chosing filters and populating the Array, I would like to return the whole thing (combinedRanges) in another output range.

I have written the following code, but it is not returning the desired outcome. I might have made it too complicated, however, im looking for any help you can give me.

Column "E:I" and "K:M" is my source range
Column "AC:Aj" is my destination range

CODE:

Please Login or Register  to view this content.

**jindon** · 02-23-2023, 04:15 AM

Does it need to be Global ?

Please Login or Register  to view this content.

**Fishtail** · 02-23-2023, 07:03 AM

Hi jindon

Thanks for your reply. The code works, however, the output data gets overrided when I use the code for the second time.

Im not sure it needs to be Global. Maybe I did not explain myself correctly.
What I mean is that the populated cells in the array needs to stay everytime I use the sub-routine and be resized to fit the next range I wanna save. And only when I am ready to output, the saved ranges are returned to column AC:AJ.

As explained, I would like to filter on my data using cell A4 and A6. Once filtered, I would like to save my range. This will be done multiple of times.

Hope this makes sence.

**jindon** · 02-23-2023, 07:56 AM

Do you want it directly to output?

Please Login or Register  to view this content.

**Fishtail** · 02-24-2023, 05:57 AM

Thanks, jindon. This is really good stuff. Both subroutines are working.

Have a nice weekend!

Save dynamic ranges into Global array and return combined ranges

LinkBack

Thread Tools

Rate This Thread

Display

Save dynamic ranges into Global array and return combined ranges

Re: Save dynamic ranges into Global array and return combined ranges

Re: Save dynamic ranges into Global array and return combined ranges

Re: Save dynamic ranges into Global array and return combined ranges

Re: Save dynamic ranges into Global array and return combined ranges

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Dynamic chart ranges without naming lots of ranges

[SOLVED] Use 2 Different Named Cell Ranges To Return Values From 1 Of the Ranges In Formula

Dynamic ranges in array formulas.

Save Ranges in Array

[SOLVED] VBA Code To Return The Number Of Columns Between Two Dynamic Ranges.

VBA Array formula for dynamic ranges

Can you create dynamic named ranges containing array formulas?

Bookmarks

Bookmarks

Posting Permissions