Dynamic Range

for reference

What if you want a horizontal range on a vertical sheet?

Edit: In thinking more about it, I guess you would put all horizontal ranges on the horizontal sheet and visa versa. I need more coffee.

LOL....

Quote:

---

Worksheets("Sheet1").Range("A1", Cells(Range("A65000").End(xlUp).Row, Range("XX1").End(xlToLeft).Column)).Select

---

this allows the range to grow and get smaller

solved?