Hello Dave,

I can't find any similar example at the site you mentioned.


Low

--
A36B58K641


"Dave Peterson" wrote:

Visit Debra Dalgleish's site for some techniques for resetting that
lastusedcell.
http://www.contextures.com/xlfaqApp.html#Unused

Mr. Low wrote:

Dear Sir,

I need to copy a formula from cel C1 to C1680 (the last line) in folowing
worksheet:

< There are no spacing between rows

A B C D
1 xxxxx xxx xxx
2 xxxxx xxx xxx
3 xxxxx xxx xxx
4 xxxxx xxx xxx
5.. xxxxx xxx xxx ...
....
1293 xxx xxx xxx

Column C is blank, if I strke CTRL END it would go to the end of the
Worksheet at C65536.

If I strke CTRL SHIFT END it would block up C1:I1600.

May I know is there any key board shortcut to highlight column C from C1 to
C1293 only ?

Kind Regards

Low

A36B58K641

--

Dave Peterson