Extract address from specific blocks of named range

[Sintek]

Hi Guys

Just can't get this figured out...
In attached I have a range A3:D19

I am wanting to extract the individual range addresses per row cluster per column i.e.

loop x y z and extract team range addresses

For Method x A = B5:B20, B = C5:C7, C = D5:D9
For Method y A = B10:B10, B = c10:C14 , C = D20:13
and same for z

[JLGWhiz]

How about using arrays for the range addresses with an individual array for each method, then you can loop the arrays and the items in the arrays to do the extraction.

[Sintek]

about using arrays for the range addresses

This is what I am wanting...just can't wrap my head around it...Blank !!!

[SjonR]

I'm not sure if this is what you are looking for, but with the method in H4 and the team in I4 it show the range-address in J4:

Please Login or Register  to view this content.

And do you know why i can't post a file here?

[Sintek]

Hi SjonR

Nope, tx anyway...
Color coding is for explanation purposes only...
Teams Method A B C x y z are not std and can change...

[Vraag en antwoord]

put the expected outcome in the sample file.

[Sintek]

Expected outcome is explained in detail in post1

This solves...No variable declarations as they are public

Please Login or Register  to view this content.

Edit my bad guys...Just noticed that my post 1 refers another sample file...

This was expected outcome...

$B$5:$B$9
$C$5:$C$7
$D$5:$D$9
$B$10:$B$13
$C$10:$C$14
$D$10:$D$13
$B$15:$B$19
$C$15:$C$19
$D$15:$D$19

[JLGWhiz]

And do you know why i can't post a file here?

You have to click on the Go Advanced button, then use the Manage Attachments facility. The paper clip icon was removed because it never worked properly.

[SjonR]

Thanks Whiz

[Vraag en antwoord]

sorted by column

Please Login or Register  to view this content.

[Sintek]

Very close VenA

Well done...Thanks

Please Login or Register  to view this content.