How do you copy from c1 to c1680 if col C is BLANK as you state?
sub copyit()
lastrow=cells(rows.count,"a").end(xlup).row
cells(1,"c").copy cells(lastrow,"c")
end sub

--
Don Guillett
SalesAid Software

"Mr. Low" wrote in message
...
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