Replies

Brooke,

It works like a charm, and I understand MOST of it. I follow everything that happens up to the first LOOP. And I understand the third DO..LOOP. What I don

Yes, that is the version that works for me also.

Thanks.

Hi Diego,
I tried your formula and it works great also. I like the added advantage of having the rows already selected so they can be deleted or hidden.

As usual, everyone in this forum is so helpful.

Thanks

Legare,
I am confused about one portion of your formula. I understand that you are saying IF A1 space, AND IF..
and this is where I get confused. The formula reads SUM(B1,E1)— shouldn’t that be B1. E1(i.e. the range, rather than just the 2 cells)? And doesn’t it need to say something about the SUM such as SUM(B1.E1)=0?

Colin,
Your formula works great!

Thanks!!

You are absolutely correct! When I ran them from the Tools/Macro list they worked just fine. It was the buttons that didn’t work. I reassigned the macros and they now work fine!

Thanks Andrew, Mark and Legare .

Yes, I searched all local drives and it only found one copy – the one on the E drive.

And I just tried creating a folder in C:Program FilesMicrosoft OfficeOfficeXlstart – and putting personal.xls there. That didn’t work either.

No, BUT I just realized something! Yesterday the IT dept installed Win98 on my PC. AND they divided my hard drive into C, D, and E. The location of personal.xls has moved from C:Program FilesMicrosoft OfficeOfficeXlstart to E:Program FilesMicrosoft OfficeOfficeXlstart.

So, could Excel be confused even though there is only one personal.xls?

Hi Andrew,
I did as you said and there is only one copy of personal.xls on my system. I moved it out of xlstart and then opened Excel and recorded a macro in a clean version of personal.xls. Then I replaced the new version with the old version – with the same results!?

I don’t have a clue of what to do next – do you?

The NextSheet suggestion will work fine. I am curious though, why do you refer to it as oNextSheet ?

OK. Split-leaf philodendron is a name I know. Seriously, you all have been great – with your advice and your humor. Thanks a bunch!

Thanks for all the input. I spent my lunch-hour comparing monitors on the net .

BTW what exactly is a cheese plant?

Thanks again all. And Leif, when you look at it that way, I guess you are right – its time for a new monitor.

Now can I ask you all to look into your crystal ball and tell me if I need to run out and buy one yesterday? My concern is that it is going to just die without warning and I will be forced to buy one rashly. Worse yet, my fear is that its death will be violent, while I am using the PC . Should I be afraid to use it?

Thanks guys for the input. I really appreciate it. I have tried deguassing and it really doesn’t seem to help. About repairs vs buying new – As I ran thru Best Buy yesterday I noticed a 19″ monitor for $499 (original price on mine was $655). Would I expect to pay hundreds of dollars for repairs? Or are you suggesting that repairs would only be a short term fix?

No spoof, unfortunately . And the monitor is not under warranty (just my luck, the warranty ran out in January and it is 4 years old). Is it really worth finding someone to repair it or do people just buy new ones when monitors die? I really don’t want to invest in a new one if repairing this one will work. But I also don’t want to waste my money in repairs if the end result will be buying a new monitor anyway. I’m open to all suggestions/advice.