Syntax for filldown based on another rows length and specific filter

Hi, I am looking for how you set up a range and use it to fill down based on another rows length.

For example, If I know column A will always be my longest column, and all my formulas are in row 2, how can I list filldown ranges efficiently.

For example, could I do B2:D2 and E2:G2 at once (anything with a break in between, or do I need to list them separate, can I even do continuous groups together, or is it row by row? Thanks, quite new to VBA, trying to learn the syntax to write them myself, since record a macro seems to record keystrokes for the most part (it will say this row to that row instead of determining the last used cell etc.)

Another one that's been troubling me is how to reference a specific value in a filter rather than its relative reference in a list.

Thanks in advance!

Thanks, that is just what I was looking for. So you can list multiple ranges separated by a column, and if we define the range like that, it is referenced as so.

Very helpful, can't thank you enough.