Thanks Graham,
However when I tried using the code you pasted in it doesn't work. There seem to be quite a few little erros that stop it working. The first one was something about the line:
If Err 0 Then -- It doesn't seem to like this
and another error occurs for the line:
End if -- It says there is no bolck if
I'm not very good with VBA so don't really know how to fix it if i can - but for some reason it doesn't work.
|