for reference
Printable View
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....
this allows the range to grow and get smallerQuote:
Worksheets("Sheet1").Range("A1", Cells(Range("A65000").End(xlUp).Row, Range("XX1").End(xlToLeft).Column)).Select
solved?