Jase,

Are you selecting the whole column, or just a data range?

It may pay to post you code to the newsgroup, as it
soulds like you may have some sort of looping error.

HTH,

Paul Mac.
-----Original Message-----
Hi All

I don't know if anyone will beable to help me, but my
problem is as follows.

I have a section of code that gets one column and fills
it
into the next column. Now that doesn't sound very hard
does it?

So I do that but unforunately every time that I execute
this piece of code the computer hangs. At first I
though
it might be a calculation thing so I have turned
calculation to manual to stop this problem but I can not
think what else might be around to make the programme go
this slow. There is only around 15 data values 2 of
which
are formulas being filled and nothing relies on the
results of the fill.

Hope I haven't confused anyone. But do you know of any
other objects that I might beable to turn off to make
this
operation quicker??

Thanks heaps
Jase
.