View Single Post
Old 26-05-2005, 12:39   #9
absthechatter
Inactive
 
Join Date: Dec 2004
Posts: 310
absthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really nice
Re: Microsoft Excel Help Needed

Quote:
Originally Posted by gazzae
Yes, you would have to get the value when you enter the cell, stick it in a public variable and then compare it with the value when you exit the cell.

If you want I can write it for you after lunch.
That would be brilliant, thank you.

One other question (probably not the last!!) on some machines, that code works perfectly, on others I get runtime error '1004': Unable to set the ColorIndex property of the interior class. Debug does not appear to help. They are all running same versions of software. Any suggestions?

Many thanks again

Abs
absthechatter is offline   Reply With Quote