Brill, thats a lot better than before, also, I have changed it do
rng2.Value instead of selecting it and then doing activecell.value. I
think that will be faster.

Just another question.....im using rng2.Value = Now() but I could
really do with just the time and not the date, is that a command?

Duncan