Hi all,
I'm trying to set up a dynamic range - got the columns sussed, but the rows are a bit trickeir. Here is my scenario.
I have a range of values in the Y and Z column. These can appear anywhere in the column.
I have values in the G column. These can start anywhere from Row 16 to Row 39.
I want to set up my dynamic array FROM:
The FIRST non zero entry in the G column AFTER row 15.
TO:
The last non zero entry in EITHER row Y or Z.
I know for the TO part I can do:
Cells(Rows.Count, "Z").End(xlUp).Row
Well, that covers the Z column anyways - however it doesn't restrict itself to non zeros. . .
Any ideas??
Thanks
John
I'm trying to set up a dynamic range - got the columns sussed, but the rows are a bit trickeir. Here is my scenario.
I have a range of values in the Y and Z column. These can appear anywhere in the column.
I have values in the G column. These can start anywhere from Row 16 to Row 39.
I want to set up my dynamic array FROM:
The FIRST non zero entry in the G column AFTER row 15.
TO:
The last non zero entry in EITHER row Y or Z.
I know for the TO part I can do:
Cells(Rows.Count, "Z").End(xlUp).Row
Well, that covers the Z column anyways - however it doesn't restrict itself to non zeros. . .
Any ideas??
Thanks
John