Combining Two Scripts

All the time.... I suppose.

Sorry shg, I am not a programmer, so I am not getting what you mean. I don't even know, if they need to be combined. If I use them as they are in the worksheet code for sheet 1, I get an error 1004.

I just want them to do what they each do.... all the time.

Regards.

If I use both scripts together (one below the other) in a fresh workbook as follows:

Please Login or Register  to view this content.

then all works well.

But if I use them in one of my existing workbooks, it gives me an error in the line ".ColorIndex = 20". The prompt says: "Unable to set the ColorIndex property of the Interior class" (see attached).

FYI, I have two sheets in the workbook. sheet1 is labelled 'Members' and sheet2 is labelled 'Analysis'.

I don't understand why both features will work in a fresh workbook, but not in my existing workbook.

Sorry snb,

Your script does not work. Not even in a fresh worksheet.

However, I have done some more digging and found that I am getting an error because the worksheet is protected. If the workshett is not protected, then everything works well. But I need my worksheet to be protected. So I'll just forget about running this script.

Is there any other way, I can know which cell is selected?

Thanks shg,

Yes, I can do that. But I also noticed that while it highlights the selected cell, it also removes background colours from all other cells. That is not good, as some of my heading cells have been assigned background colours.

If somehow, I can define a range in the script, then maybe it would be worth unprotecting and re-protecting the sheet before and after every move.

Thanks snb,

It works now, but how do I prevent the script from removing background colours from my heading cells. I would like this script to affect cells A8:AE100 only. Where can I define that range in this script?

Thank you very much snb,

It's all working very well now. Thanks again for your input and your help.

You can mark this thread as 'solved'.

Regards.