Thread: More efficient method to copy-paste values in place?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
  
Posts: 441
Default More efficient method to copy-paste values in place?
Thanks.

"Frank Kabel" wrote:

Hi
with
ActiveSheet.UsedRange.Columns(23)
.value=.value
end with

"quartz" wrote:

I have a sheet that has about 40,000 rows and each row contains a formula in
column "W" (23). I need to convert the formula to values. My current code
follows:

ActiveSheet.UsedRange.Columns(23).Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues

Although the above works, I'm sure there is a more efficient method that
could be written in a single line of code. Can anyone help me out?

Thanks much in advance.
Reply With QuoteReply With Quote