Search results

I will take the warning and not use it, but many thanks anyway. Regards, Matt

Thanks guys. I don't have XL 2002 or 2003 so I would be very gratefulif you could tell me how to do it in VBA. Many Thanks, Matt

Is it possible to change the colour of the tabs on a worksheet. If it is I would be grateful if you would let me know how. Regards, Matt

Thank you I had thought of VBA but its going to take along time to work out the code generated on the links. Look forward to the challenge though. Thank you.

I would be more than happy to use a lookup table but I was struggling with needing to check three ranges to determin the value of a cell. i.e If a number from 1 - 9 does not appear in 1 of 9 cells in a row & If a number from 1 - 9 does not appear in 1 of 9 cells in a colum & If a number from...

I wish to nest more than 8 If Statements 3 times ie. Range A1 needs to test that the value 5:- 01 - Does not appear in a Row of 9 columns - say B1:B9 02 - Does not appear in a Column of 9 rows - Say A2:A10 03 - Does not appear in an array of a 3x3 grid - Say an array named "grp1" Is this at...

Thanks to all. Regards, Matt

Thank you for your help. The change as suggested was intended to be in another cell. Thanks, Matt Having responded I realised that I hadn't asked the right question. What I should have asked was:- How can I reverse the sign of a number i.e a negative number to a positive and a postive number...

You will have to forgive me, I have actually asked this before but have lost the answer. I was given a very simple solution. I have a number of negative numbers that I wish to change to positive. Somethng must have changed to this forum since my last visit on 25th November 2005 as cannot...