Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Performance issues, looking for alternate solutions
We have a large spreadsheet we build every night for our floor traders, which
combines information from Excel (pricing from Bloomberg) and Access (accounting data), using VBA to mediate. There is a major performance problem I'd like to fix. One of the major steps runs calculations combining this information, using sheets in Excel to do this. This is very slow. The same code running in VBA arrays works much faster, 2 to 3 times. The problem is that when the results are pasted back into Excel, any existing formatting is erased. What I'd like to do is keep the formatting that's currently on the sheet, and paste in just the values we're calculated in the array. This has so far eluded me. Any suggestions? Maury |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Performance issues, looking for alternate solutions
Not sure what you mean by pasting back from an array. If it truly is paste, you can use paste special: Selection.PasteSpecial Paste:=xlPasteValues -- kkkni ----------------------------------------------------------------------- kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754 View this thread: http://www.excelforum.com/showthread.php?threadid=26849 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Performance issues, looking for alternate solutions
kkknie wrote ...
Not sure what you mean by pasting back from an array. If it truly is a paste, you can use paste special And if it isn't a paste, you can use the Range's Value property e.g. vntArray = Sheet1.Range("$C$2:$E$5").Value Sheet1.Range("$C$2:$E$5").Value = vntArray Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula with many solutions. | New Users to Excel | |||
Looking for Solutions | Excel Programming | |||
Spreadsheet Solutions | Excel Programming | |||
Using VBA: Trying to write new solutions ONLY | Excel Programming | |||
Looking for Solutions | Excel Programming |