A better CTRL A select
 

Hello

What is the code that would scan rows for values, and then start ro
selection on row1 to the end of the rows that doesn't have any value
below it?

Thanks

--
Ambrosi
-----------------------------------------------------------------------
Ambrosia's Profile: http://www.excelforum.com/member.php...fo&userid=2814
View this thread: http://www.excelforum.com/showthread.php?threadid=48011

A better CTRL A select
 

ctrl-home to put the cursor in cell A1. Then shift-ctrl-end to selec
to the last used row and last used column.

Does that help

--
MrShort
-----------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...fo&userid=2218
View this thread: http://www.excelforum.com/showthread.php?threadid=48011