Hi folks

I have a line in my worksheet I cannot delete, it isnt a VB control,
as in design mode I cant hightlight it and delete it.
Even if I delete the rows above and below it at the same time it
remains on the sheet...

what is this object, I suspect it is some VB left over...

cheers
John

does the line run all the way to the end of the worksheet or does it stop?
Anyway, try the Drawings toolbar, pick the arrow pointer and see if you can
select it with that + delete.

"John in Wembley" wrote:

Hi folks

I have a line in my worksheet I cannot delete, it isnt a VB control,
as in design mode I cant hightlight it and delete it.
Even if I delete the rows above and below it at the same time it
remains on the sheet...

what is this object, I suspect it is some VB left over...

cheers
John

On Mon, 27 Aug 2007 11:58:01 -0700, rdwj
wrote:

does the line run all the way to the end of the worksheet or does it stop?
Anyway, try the Drawings toolbar, pick the arrow pointer and see if you can
select it with that + delete.

thanks, no luck with the drawing toolbar, its about 5cm and is not
bound by columns, eg if I move column width there is no growth in the
length of the line...
that said, the start of the line seems bound to a column...

interesting.
What happens if you copy the cells that show the line to another area? Does
the shape reappear?

"John in Wembley" wrote:

On Mon, 27 Aug 2007 11:58:01 -0700, rdwj
wrote:

does the line run all the way to the end of the worksheet or does it stop?
Anyway, try the Drawings toolbar, pick the arrow pointer and see if you can
select it with that + delete.

thanks, no luck with the drawing toolbar, its about 5cm and is not
bound by columns, eg if I move column width there is no growth in the
length of the line...
that said, the start of the line seems bound to a column...

"John in Wembley" wrote in message
...
that said, the start of the line seems bound to a column...

In that case what happen if you delete that column?
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

have you tried the Control Toolbox to check if it is a designed shape with
height 0?
Otherwise, write a macro to select every shape on the worksheet....

"John in Wembley" wrote:

On Mon, 27 Aug 2007 11:58:01 -0700, rdwj
wrote:

does the line run all the way to the end of the worksheet or does it stop?
Anyway, try the Drawings toolbar, pick the arrow pointer and see if you can
select it with that + delete.

thanks, no luck with the drawing toolbar, its about 5cm and is not
bound by columns, eg if I move column width there is no growth in the
length of the line...
that said, the start of the line seems bound to a column...