Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace formula's in two columns with the value's with VBA
Hi all, I have two columns that have formula's in and i need to replace
the formula's with the values. The page can be up to 60,000 rows long, so the code need to be quick if possible. Thanks in advance Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace formula's in two columns with the value's with VBA
Select the range of cells, and right click on the right border.
Keeping the right mouse button down, drag the region one column to the right, then back to its original location. On the pop-up menu that displays, select "Copy Here As Values Only". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Les Stout" wrote in message ... Hi all, I have two columns that have formula's in and i need to replace the formula's with the values. The page can be up to 60,000 rows long, so the code need to be quick if possible. Thanks in advance Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace formula's in two columns with the value's with VBA
copy|paste special values (for each column if they're not adjacent) should go
pretty fast. Les Stout wrote: Hi all, I have two columns that have formula's in and i need to replace the formula's with the values. The page can be up to 60,000 rows long, so the code need to be quick if possible. Thanks in advance Les Stout *** Sent via Developersdex http://www.developersdex.com *** -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace formula's in two columns with the value's with VBA
in code
columns(10).copy columns(10).PasteSpecial xlPasteValues columns(14).copy columns(14).PasteSpecial xlPasteValues if they are adjacent set rng = Columns(10).Resize(,2) rng.copy rng.Pastespecial xlPasteValues -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... copy|paste special values (for each column if they're not adjacent) should go pretty fast. Les Stout wrote: Hi all, I have two columns that have formula's in and i need to replace the formula's with the values. The page can be up to 60,000 rows long, so the code need to be quick if possible. Thanks in advance Les Stout *** Sent via Developersdex http://www.developersdex.com *** -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combo box and value's | Excel Discussion (Misc queries) | |||
20,000 records, 30 columns, look-up formula's I need speed!!!!! | Excel Discussion (Misc queries) | |||
Lock Columns and Hide Formula's | Excel Worksheet Functions | |||
Sum amount if = 2 value's | Excel Discussion (Misc queries) | |||
Multiple lookup value's | Excel Worksheet Functions |