Tuesday, 13 August 2013

Offset to two dynamic ranges

Offset to two dynamic ranges

I have two dynamic ranges that I'll call rng1 and rng2. I have a for
each/next loop going through rng1 (example: A2,A3,A4,A5, etc...) I also
need to get the same row value from rng2 (example: T2,T3,T4,T5, etc), but
the range isn't always the same so a standard offset won't work (that I
know of).
Any ideas?
How I set up the range (excludes the header and finds the last row)
lastrowTN = ws.Cells(65536, phcell.Column).End(xlUp).Row
Set rngtocopyTN = ws.Range(phcell.Offset(1, 0).Address, Cells(lastrowTN,
phcell.Column))

No comments:

Post a Comment