Range(yourRange).Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues


wrote in message news:T2xQd.65996$2p.48322@lakeread08...
All -

I'm cycling through a large range (~25x5300 cells) and setting .formula
= .value to accomplish paste-special-values. There has to be a quicker
way to copy and paste in place.

When I repeat the macro recoder code, it somehow screws up in the
spreadsheet, and I get ghost cells on my screen--cells overlaying cells
that aren't really there.

Anyway, - what's the best way to do this?

...best, Hash