No reason to loop if it is all one range

with Range("A1:Y5300")
.Formula = .Value
End With

--
Regards,
Tom Ogilvy

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