Make sure you put the code in a *worksheet* code module, not a regular
code module (as I told you before), and that you adjust the range for
your target (I used "A1").

In article ,
"pantelis" wrote:

I have done what you said but I cant get it to work for some reason. I
simply copy this code into the sheets VBA but nothing happens.