Paste Special in macro not working

[scrupul0us]

Ive got an entire column of formulated text in a column, and im trying to copy just the result over to another column, when I manually do paste special > VALUES it works fine. When it embedded in my macro it copies down the first value of the reference column for the entire destination column:

    Columns("D:D").Select
    Selection.Copy
    Columns("C:C").Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False

 

[Eric B]

I noticed you're turning calculation to manual at the start and back to automatic at the end- shouldn't you add a Calculate command after

Selection.AutoFill Destination:=Columns("D:D"), Type:=xlFillDefault

or just do away with turning it to manual calculation altogether?

 

[scrupul0us]

well i\now that im on my home machine it worked ust fine WTF!?! any ways.. now im having another issue...

im trying to insert a new blank row at the top of my worksheet and excel is babbling about how that could attribute to data loss and wont let me... even if i macro this action i get an error... can this be gotten rid of?

 

[scrupul0us]

Im noticing its one column in the set of data that is causing this problem... its full of zip codes... but its not formatted any special way or linked... ideas?

 

[AussieRob]

How much data is in your col? Does it go all the way to row 65000++? I know i have had problems with excel and large amts of data.

 

[scrupul0us]

this months report is only 155 lines...

i have columns a:u and i can move each of them down except col F... wierd

 

[scrupul0us]

bump.. anyone?

 

[scrupul0us]

Actually I fixed it... the column that was causing problems was one where I copied special that put "" in all the maining rows for the entire page and excel cant push cells of the page, hence the error...so i just ran a thinger to delete all empty rows again and it worked like a charm... finally after 2 weeks this is done