PDA

View Full Version : [SOLVED] Dynamic Range



mdmackillop
04-18-2010, 11:40 AM
for reference (http://www.vbaexpress.com/kb/getarticle.php?kb_id=1067)

lucas
04-18-2010, 11:59 AM
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.

Aussiebear
04-19-2010, 02:03 AM
LOL....

Jayfunk360
12-30-2013, 03:53 AM
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

gert.thys
12-22-2015, 12:45 PM
solved?