(xlDown) not working properly!

A

aapp81

i have columns A2:T2 selected and then i do this:
Range(Selection, Selection.End(xlDown)).Select
but it only selects up to the last row in column T but other cols ar
longer...
is there anyway to fix this so that it selects down to the longest col
 
D

Dick Kusleika

aapp81

It should select down to the last value in column A, not T. Anyway, try
this

Selection.CurrentRegion.Select

and see if that doesn't give you the proper range.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

aapp81 said:
i have columns A2:T2 selected and then i do this:
Range(Selection, Selection.End(xlDown)).Select
but it only selects up to the last row in column T but other cols are
longer...
is there anyway to fix this so that it selects down to the longest col?
Click to expand...
creating financial statements
 
A

aapp81

Dick said:
*aapp81

It should select down to the last value in column A, not T. Anyway
try
this

Selection.CurrentRegion.Select

and see if that doesn't give you the proper range.
*
Click to expand...

yeah, i thought about doing that but i have headings in A1:T1 and doin
"currentregion" selects them as well... and i want it to start fro
row
 
T

Tom Ogilvy

set rng = selection.CurrentRegion
if rng.row = 1 then _
set rng = rng.offset(1,0).Resize(rng.rows.count-1)

rng.Select

--
Regards,
Tom Ogilvy


aapp81 said:
yeah, i thought about doing that but i have headings in A1:T1 and doing
"currentregion" selects them as well... and i want it to start from
row2
Click to expand...
creating financial statements
 
V

Vic Eldridge

Here's one way...

With Selection
.Resize(.CurrentRegion.Rows.Count - .Row + 1, _
.CurrentRegion.Columns.Count).Select
End With


Regards,
Vic Eldridge
 
V

Vasant Nanavati

Hey Vic ... long time no see!

Regards,

Vasant.

Vic Eldridge said:
Here's one way...

With Selection
.Resize(.CurrentRegion.Rows.Count - .Row + 1, _
.CurrentRegion.Columns.Count).Select
End With


Regards,
Vic Eldridge


aapp81 <[email protected]> wrote in message
i have columns A2:T2 selected and then i do this:
Range(Selection, Selection.End(xlDown)).Select
but it only selects up to the last row in column T but other cols are
longer...
is there anyway to fix this so that it selects down to the longest col?


------------------------------------------------
[/url]


~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
Click to expand...
creating financial statements
 
V

Vic Eldridge

Hey Vic ... long time no see!
Regards,

Vasant.
Click to expand...


Howdy Vasant.

Yeah it's been a while. I wonder how many Application.ScreenUpdating
= False's I missed out on. ;-)

I see you've been crowned an MVP. Well Done !


Regards,
Vic Eldridge
 
Top