Is there anyone at Microsoft you can ring?

These Newsgroups are not Microsoft, they are a peer to peer help forum.

In your original post you said:

"For some reason the INSERT ROW at the bottom of the list doesn't appear any
more. "

What INSET ROW are you talking about?

--

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


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


"offanon" wrote in message
...
Hi Sandy,

Thanks for your persistance with this. No, there is no code to be seen, I
haven't created any macros in this workbook at all. It's just gone
"Faulty"
all of a sudden. Can't figure it out.

Is there anyone at Microsoft you can ring?

"Sandy Mann" wrote:

Well, my next guess would be that you have an event macro which runs when
you click into the last row. Is there an code to be see when you
right-click on the sheet tab and select View code?

--
HTH

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


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


"offanon" wrote in message
...
In short, the list is a sales record containing info such as Salesman,
Customer, Product, Profit etc. Each new line is a new sale. In order to
enter
a new sale to the list, I have been clicking into the Insert Row at the
bottom of the list and entering the new data. This row no longer
appears
and
my list is surrounded by a blue border which doesn't move whether I
click
inside the list or not. Nor does it allow me to drag the dimensions of
the
list like I can with others.

Hope this makes sense.

Jon

"Mike H" wrote:

Hi,

I may be asking the obvious but if 'Insert Row' wasn't missing from
your
list then what would it do and more importantly, how would it do it.

Mike

"offanon" wrote:

I created a list in a worksheet that I have spent hours putting
together. It
has been working perfectly for weeks, until now! For some reason the
INSERT
ROW at the bottom of the list doesn't appear any more. I have tried
several
ways to get around this, including unsorting all of my data in the
list
so
that every line appears, then converting the list to range then back
to
list.
This doesn't help. The nearest I came to fixing it was to copy the
list
and
its contents to a new worksheet and messing about with it there for
a
bit.
This kind of got it working (on the new worksheet) but there is a
lot
of
conditional formatting in some of the rows which won't copy into the
new rows
as it did before. The data that is entered into this list populates
about 5
more sheets with vital data for the buiness so this is a big
problem.
At the
moment I'm having to manually insert a row each time a new sale
needs
recording. This is fine when I'm doing it but the other staff can't
seem to
cope with it as they are useless with technology.

Any help would be greatly appreciated.

Thanks

Jon