| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
More efficient method to copy-paste values in place?
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you change the default paste method? (paste values) | Excel Discussion (Misc queries) | |||
| Most efficient method in Excel? Mouse or Keyboard keys? | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Looking for faster method for Copy & Paste | Excel Programming | |||
| How do i compare values from two sheet and copy & paste if values match? | Excel Programming | |||
![quartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
