help to tidy up or improve macro usage

Hi all

Below is a link to workbook I started which I feel can be done alot better so hoping for some extra thoughts to guide me in the right direction.

http://myweb.tiscali.co.uk/terryj/sudokuhelper.xls

You can pretty much guess what the workbook is about by the file name, and although I enjoy sudoku, I enjoy using excel more and finding new challenges, this being my latest one.

One issue I have at mo is that I don't know VBA yet but I plan to rectify that soon.

There is already a game setup, an easy one for explaination purpose.

In the game there is a 'Update' and 'Max' macro I am using. Update looks for single cells remaining only and when hit updates the relevant cells with the new data. Max does pretty much the same thing except that it loops through the update process until there are no more single cell entries remaing. At this point you have to do your own work to carry on with the puzzle.

So it's more of a helper than a solver at present and simply updates any cells that only have one possible option.

An issue I have is that when you hit the Max or Update button the process simple looks terrible, with a load of automatic copy and pasting that causes the screen to flicker like made while there are still single entry cells remaining.

So, any thoughts on how to go about tidying the workbook up would be very much appreciated no matter how small the contribution is.

Many thanks all and appologise if my explaination isn't very clear.

ok thanks, nice program that, but I was hoping to get or try to get a better understanding on how to improve on what I've already done, if that makes sense, whether it be by normal formula equations or VBA, more of a it would be better if you tried this scenario. As a beginner in VBA, to compare an improved version of what I've done would help me follow the changes, but looking at complex completed other programs (or at least it is to me just blows my mind at this moment in time.

Thanks for the link though it will give me many days of challenges within the game.