Selecting a column

**blinks** · 01-28-2010, 04:38 AM

I need to select the whole column ABOVE the active cell. Ctrl-Shift-UpArrow is no good because it stops at the first blank cell. And selecting the whole column is no good either because when I subsequently paste into the column, it pastes in all the empty cells of the column, meaning my worksheets expands from a few hundred rows to 1 million!

Shift-Home does what I want on rows. Is there an equivalent for columns?

TIA

**DonkeyOte** · 01-28-2010, 04:51 AM

Do you mean perhaps: SHIFT + PAGE UP ?

**teylyn** · 01-28-2010, 04:55 AM

select the whole column and then do Shift Ctrl UpArrow

**teylyn** · 01-28-2010, 04:56 AM

DO, that will only select one page worth of data, if you're several pages down from row 1, you'll need to hit it repeatedly.

**blinks** · 01-28-2010, 05:03 AM

Thanks for your replies; unfortunately, I'm still in the same boat.

Shift-PgUp only selects a page-worth, and because the page has around 90K lines, I needto write a macro to automate things.

**teylyn** · 01-28-2010, 05:06 AM

did you read my first reply? Did you try it?

**teylyn** · 01-28-2010, 05:11 AM

Maybe a bit more detail:

with Row 1 visible on the screen, click the column header to select the whole column
Then hit Ctrl-Shift-UpArrow. This will select from row 1 down to the last occupied cell in the column.

If Row 1 is not visible when you click the column header, the Ctrl-Shift-UpArrow will not change the selection and it will remain at the whole column.

Dunno why, just found that it does it that way.

**blinks** · 01-28-2010, 05:12 AM

Thanks teylyn; yes, tried that, but no go - am I doing something wrong? After selecting the whole column, I then clicked on the bottom cell, then did the Ctrl-Shift-Up; but once again, it stops at the first blank cell.

**blinks** · 01-28-2010, 05:15 AM

Wow, that did the job very beautifully!

Thanks, Teylen!

**blinks** · 01-28-2010, 04:02 PM

Unfortunately, a hitch .... the "select column, then do a Ctrl-Shift-Up" method works beautifully when manipulating the spreadsheet manually.

However, when converting those movements into a macro via "record macro", it doesn't work; the whole column continues to be selected.

The code created by "record macro" is -

Columns("E:E").Select
Range(Selection, Selection.End(xlUp)).Select