HIGHLIGHTING A COLUMN OF DATA
 

I HAVE DATA IN A COLUMN, SAY IN A1 THROUGH A300.

I also have a "name" for the last cell, A300, call it "END".

Question: How do I highlight the entire column...cells A1 through A300
without having to drag the mouse...so that I can copy and paste it to another
column (for sorting in numerical order)??

Thanks.,

FLKulchar

HIGHLIGHTING A COLUMN OF DATA
 

click on the first cell and then touch
SHIFT-END
SHIFT-down arrow
--
Gary's Student


"F. Lawrence Kulchar" wrote:

I HAVE DATA IN A COLUMN, SAY IN A1 THROUGH A300.

I also have a "name" for the last cell, A300, call it "END".

Question: How do I highlight the entire column...cells A1 through A300
without having to drag the mouse...so that I can copy and paste it to another
column (for sorting in numerical order)??

Thanks.,

FLKulchar

HIGHLIGHTING A COLUMN OF DATA
 

Thank you!!!!!!!!!!!!!!!!!!!!!!!!

"Gary''s Student" wrote:

click on the first cell and then touch
SHIFT-END
SHIFT-down arrow
--
Gary's Student


"F. Lawrence Kulchar" wrote:

I HAVE DATA IN A COLUMN, SAY IN A1 THROUGH A300.

I also have a "name" for the last cell, A300, call it "END".

Question: How do I highlight the entire column...cells A1 through A300
without having to drag the mouse...so that I can copy and paste it to another
column (for sorting in numerical order)??

Thanks.,

FLKulchar

HIGHLIGHTING A COLUMN OF DATA
 

Range("a1:" & Range("end").Address).copy range("b1")

--
Don Guillett
SalesAid Software

"F. Lawrence Kulchar" wrote in
message ...
I HAVE DATA IN A COLUMN, SAY IN A1 THROUGH A300.

I also have a "name" for the last cell, A300, call it "END".

Question: How do I highlight the entire column...cells A1 through A300
without having to drag the mouse...so that I can copy and paste it to
another
column (for sorting in numerical order)??

Thanks.,

FLKulchar